Analysis Services Live Connection, Gateway error

RMDNA · ‎12-07-2017

All,

I'm attempting to publish a PBIX with a live connection to a cube. However, on publish, I get the error:

However, I have an enterprise gateway on which I am an admin, and has a successful connection to that cube:

Any support? Thanks.

Anonymous · ‎12-10-2017

@RMDNA,

I am not able to reproduce your issue. Do you use the latest version of Power BI Desktop(2.52.4921.682) and use the latest version of Power BI on-premises gateway?

Regards,
Lydia

Anonymous · ‎12-07-2017

@RMDNA,

Could you please verify that if the server name and database name in the above screenshot are same as that names you use in Power BI Desktop?

The above warning could throw when you use different server name or database name in two platforms. For example, you use IP address as server name in gateway, and use machine name as server name in Desktop.

Regards,
Lydia

RMDNA · ‎12-08-2017

@Anonymous,

The server and database names for Power BI's live connection are identical to those listed as a data source in the gateway. I've done case matching as well. They are completely the same.