Forum Discussion

Raoul's avatar
Raoul
Regular Visitor
9 years ago
Solved

SSAS MD live connection

Hi there,

 

I have been trying to set up a SSAS MD live connection but after a few hours I still dont have it working.

I have followed this:

https://powerbi.microsoft.com/en-us/blog/how-authentication-with-analysis-services-live-connections-works/

 

My situation:

 

Azure VM machine: remote connection with Admin credentials

- Has analysis services MD cube.

 --> uses blablaDWH\Admin (so the domain is not just blabla but has DWH behind it).

 

- Has enterprise gateway installed and reports that the Cube is online and ready to be used.

--> this uses my organizational e-mail (e.g. [email protected]).

 

- Has Power BI desktop which has a live connection the the azure remote machine analysis service which works fine.

--> this uses [email protected] aswell.

 

I setup the gateway in manage gateways on app.powerbi.com and the connection is working (using blablaDWH\Admin user).

Now I have published a report to app.powerbi.com to share within my organization.

I open the report and I receive a:

There was a data source access error. Please contact the gateway administrator.

 

When I create a new workspace and then try to connect to the analysis service I get the the following error:

The following system error occured: the name provided is not a properly formed account name.

 

 

 

What am I missing?