cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
trisabiswas Regular Visitor
Regular Visitor

Power BI live connection to SSAS

I have created a report using SSAS in Power BI Desktop and published it. I have configured a gateway in power BI service for data refresh. I have also mapped and added a Effective Username and provided my domain upn. On testing, it shows "Online , good to go". But when I come back to view my report, I get an Error "There was a data source error." Can anybody help me with this issue? Please find below snapshots for reference:

 

Thanks in advance. Smiley Happy

 

error2.PNGManage Gateway settingerror.PNGPower BI Report (in service)

2 REPLIES 2
deepu299 Member
Member

Re: Power BI live connection to SSAS

Hi @trisabiswas  Do you see any errors in Gateway logs ? And does the user has access to the data source  (need to list them under Users tab) ?

Highlighted
Community Support Team
Community Support Team

Re: Power BI live connection to SSAS

Hi @trisabiswas,

 

From your description, it seems that you could configure the Gateway and add Data source successfully.

 

It means that your SSAS server and gateway are installed in a same domain or trusted domains.

 

So the error may be caused by Map user name.You could have a reference of this similar thread which has been solved.

 

Best Regards,

Cherry

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