cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SwaroopRoyM
Helper II
Helper II

power BI gateway connection issues

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

3 ACCEPTED SOLUTIONS
v-qiuyu-msft
Community Support
Community Support

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 

Community Support Team _ Qiuyun Yu
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

Thank you

 

Regards,

Swaroop

View solution in original post

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 

Community Support Team _ Qiuyun Yu
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

4 REPLIES 4
v-qiuyu-msft
Community Support
Community Support

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 

Community Support Team _ Qiuyun Yu
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

Thank you

 

Regards,

Swaroop

View solution in original post

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 

Community Support Team _ Qiuyun Yu
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

Yes it is, 

 

Thank you,

Swaroop

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors