Connect Power BI to Smartsheet EU Region

BretM

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.

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

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

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

BretM

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

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

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

This content has been removed.

RichardA

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