Connect Power BI to Smartsheet EU Region

BretM · 06/01/22

Hi, I'm trying to connect from Power BI to data in the Smartsheet EU region. Every solution I find seems to use the default instance, with no way to configure for use with the Europe instance.

I've already reviewed the following options:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-connect-to-smartsheet

http://smartsheet-platform.github.io/odbc-docs/#overview%C2%A0%C2%A0

I'm trying to avoid building out some API solution from scratch. Has anyone used a solution that allows connection to the Europe instance?

Genevieve P. · 06/06/22

Hi @BretM

You're correct, there currently isn't a way to connect the EU Region to Power BI. I would suggest adding this Idea to Microsoft's forum so they're aware that this is something you would find useful in the future, as they review the Power BI connector with Smartsheet.

Thanks!

Genevieve

Sébastien TOUSSAINT · 06/07/22

Hi, I have exactly the same problem regarding the integration between PowerBi and the Smartsheet EU platform. If anyone has found a solution, I'm interested!

Sébastien TOUSSAINT · 09/07/22

Hi @BretM, have you found a solution to use PowerBi on the Smartsheet EU platform?

BretM · 09/07/22

https://community.smartsheet.com/discussion/comment/342569#Comment_342569

Nothing simple, no. For now, I'm using the Smartsheet API to extract information to a database table and then connecting Power BI to those tables.

I did add a suggestion to the Microsoft forum but I haven't heard anything yet.

Sébastien TOUSSAINT · 09/08/22

Thank you @BretM for the feedback, I will report an incident to Microsoft via our customer account. See if that gets things going.

Sébastien TOUSSAINT · 09/16/22

Microsoft response :

I apologize of the late answer, but our Product Group team dedicated to this connector was confirming this point.

Unfortunately, I don’t have good news, as of now it’s not possible to change the connection URL and our Product Group does not have this planned to happen.

Our public documentation will be updated with that information:

The Smartsheet connector only supports connecting to https://app.smartsheet.com. There are currently no plans to support other domains or regions.

I understand these weren’t the news you’re hoping to hear.

Unknown · 12/15/22

This content has been removed.

RichardA · 07/23/24

Hi, did anyone manage to find a solution to this? We are keen to start pulling data from smartsheet.eu into PowerBI

Connect Power BI to Smartsheet EU Region

Answers

Categories