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

Error connecting to Azure Analysis Services from Power BI Report Server

I have created a report in Power BI Desktop (RS edition) and connected it to our Azure Analysis Services Model.

I connected using my Microsoft Account (AAD?) and can run the report without issue.

However, once it's published to our Report Server, when I access it I receive the error:

 

Couldn't connect

4 REPLIES 4
v-janeyg-msft
Community Support
Community Support

Hi, @RickyRhys 

 

Yes, Try to modify the authentication method to basic authentication on the report server. See if this works.

Reference:Power BI report data sources in Power BI Report Server - Power BI | Microsoft Docs

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If problem still persists, pls let me know.

 

Best Regards,
Community Support Team _ Janey

 

Hi Janey,

Thanks for your reply.

I am able to connect with Basic Authentication without issue. However, we have RLS enabled on our AAS Model so I need the logged in user to connect as themselves, not the hardcoded user in the report datasource Basic Authentication.

Is this possible?

Hi, @RickyRhys 

 

If you use desktop for service, You can do it. But I think it’s hard to do it in the report server. Report server is on-premises solution for reporting.

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If problem still persists, pls let me know.

 

Best Regards,
Community Support Team _ Janey

Hi Janey,

According to the Microsoft Documentation, SQL Server Analysis Services is a supported datasource for Power BI Report Server.

RickyRhys_0-1642178311921.png

 


I still have this issue as it's imperative that we can use Row-Level security for these reports.

Using a hard-coded Username and Password with Basic Authentication is not secure for us.
Any help greatly appreciated.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors