Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team,
I am trying to connect to SQL Analysis Services cube through an On premised gateway.
I have my Power BI desktop installed on one VM, the AS cube on another VM. Though i was able to connect to the cube using Power Bi desktop and able to configure the gateway successfully, once i publish this report onto the service and trying to access it getting a message "There was a datasource access error, please contact the gateway administrator".
Also, on the visual am getting a message "Couldn’t load the schema for the database model"
Can anyone help me out fixing this issue?
Thanks,
Swaroop
Solved! Go to Solution.
Hi @SwaroopRoyM,
In Power BI service, the email address which signed in Power BI will be passed to Analysis Services as the effective user. This email address should match a defined UPN within the local Active Directory Domain. If not, you will need to Map User Names, for more information, see: https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-ssas#usernames-with-anal...
Best Regards,
Qiuyun Yu
Hi @SwaroopRoyM,
Is the issue solved now? If it is, would you please mark a helpful reply as an answer to close the thread?
Best Regards,
Qiuyun Yu
Hi @SwaroopRoyM,
In Power BI service, the email address which signed in Power BI will be passed to Analysis Services as the effective user. This email address should match a defined UPN within the local Active Directory Domain. If not, you will need to Map User Names, for more information, see: https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-ssas#usernames-with-anal...
Best Regards,
Qiuyun Yu
Thank you
Regards,
Swaroop
Hi @SwaroopRoyM,
Is the issue solved now? If it is, would you please mark a helpful reply as an answer to close the thread?
Best Regards,
Qiuyun Yu
Yes it is,
Thank you,
Swaroop
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.