Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have create ssas tabular model and created a few reports in power bi desktop after installing power bi enterprise gateway and published power bi desktop reports to power bi services. and i have create a new data source for tabular data model by using data source type as analysis services.I was succussully completed the things upto here.
But i tried to access the data source i facing the big problem .So,kindly provide the why im not able to access the data source.
Please find the attaced screen shoots for more information.
Solved! Go to Solution.
Hi @rayudu,
Firstly ensure that your SSAS server and gateway are installed in a same domain or trusted domains.
Secondly, in Power BI, the effective username is passed to the gateway and then onto your on-premises Analysis Services server each time a user interacts a report connected to Analysis Services. The email address that you use to sign in Power BI with is passed to Analysis Services as the effective user. This email address should match a defined UPN within the local Active Directory Domain, if a match cannot be found, you will get errors.
You can use the following command from your workstation to find out the UPN for your account, if the UPN doesn't match the email address you sign into Power BI with, you can use “Map user names” feature to solve this issue. Assume that you if you sign into Power BI with account@thoughtfocus.com, but your local directory UPN is account@thoughtfocus.local, you can configure a mapping rule to have account@thoughtfocus.local passed to Analysis Services. For more details, please review this article.
whoami /upn
Thanks,
Lydia Zhang