SSAS MD live connection

Raoul — Mon, 03 Jul 2017 14:07:55 GMT

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. 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?

Re: SSAS MD live connection

mgmeyer — Fri, 07 Jul 2017 17:16:46 GMT

Hey Raoul, it looks like your trying to connect to your Cude using Power BI.com, this forum is specific to the on-prem Power BI Report Server. If you have questions specific to the Gateway I suggest the following forum:

https://community.powerbi.com/t5/Integrations-with-Files-and/bd-p/power-bi-services

Hope this helps, Thanks!

topic SSAS MD live connection in Report Server

SSAS MD live connection

Re: SSAS MD live connection