Live connection tabular cube

[Anonymous]

Best regard. I´ve tried to connect a tabular cube to the power bi service a report connected to analysis services and i have not benn able to do so. I´ve tried everithing i´ve seen on internet but i cann´t get it to work. The error it generates can be seen in the atached images.

I appreciate your help.

[GilbertQ · Accepted solution]

Hi there

If it is an On-Premise SSAS have you mapped the usernames from the PowerBI Service to the Domain\UserNames in the Data Source settings under Users?

[v-xicai · Accepted solution]

Hi @Anonymous ,

You need to set Map user name, replace your Power BI Service account with the your local gateway installed computer domain_name\user_name. you can refer to the link: https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-ssas#map-user-names.

Also, you may resolve the issue via the troubleshooting link: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#data-sources .

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xicai]

Hi @Anonymous  ,

Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[Anonymous]

I could not solve this issue. Could it be because my db is a developer edition?.

Tks!.

[GilbertQ · Accepted solution]

Hi there

That should not make any difference.

Just be aware that using a Dev Edition for production or live data does violate the licensing from Microsoft.

[v-xicai · Accepted solution]

Hi @Anonymous ,

You need to set Map user name, replace your Power BI Service account with the your local gateway installed computer domain_name\user_name. you can refer to the link: https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-ssas#map-user-names.

Also, you may resolve the issue via the troubleshooting link: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#data-sources .

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ · Accepted solution]

Hi there

If it is an On-Premise SSAS have you mapped the usernames from the PowerBI Service to the Domain\UserNames in the Data Source settings under Users?