Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rayudu
Regular Visitor

there was a data source access error. please contact the gateway administrator

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.Power bi 1.png

 

 

power bi 3.png

 

 

power bi 2.png

 

 

1 ACCEPTED SOLUTION
v-yuezhe-msft
Employee
Employee

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

11 REPLIES 11

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors