Forum Discussion
Live connection tabular cube
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.
- 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? 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.
- 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.
5 Replies
- GilbertQSuper UserHi 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-xicaiCommunity Support
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-xicaiCommunity Support
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
- AnonymousNot applicable
I could not solve this issue. Could it be because my db is a developer edition?.
Tks!.
- GilbertQSuper UserHi 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.