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-...
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. raoul@blabla.com).
- Has Power BI desktop which has a live connection the the azure remote machine analysis service which works fine.
--> this uses raoul@blabla.com 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?
