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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
lnicho
Frequent Visitor

Analysis services error when viewing report on power bi report server

When trying to view reports uploaded to an instance of Power BI Report Server that previously opened without error in the Sept 2022 release of Power Bi Desktop, receive the following error:

 

We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly.:
Request ID: 944ea27c-3109-15c3-0d0c-50a1ca6dd1b5
Time: Thu Oct 13 2022 11:01:47 GMT-0600 (Mountain Daylight Time)
Service version: /powerbi/libs

 

There is no connection string explicitly called out in the report; we are using Windows credentials. Any ideas what's going on here?

 

Lee

2 REPLIES 2
v-xiaoyan-msft
Community Support
Community Support

Hi @lnicho ,

 

Please try if recreated the query using same login and using  directquery type worked.

 

For the original post,you may refer to Solved: Re: We couldn't connect to the Analysis Services s... - Microsoft Power BI Community

 

Also ,as a workaround you may pass this error by changing manually  the datasource of this report in the Report Server (report->Manage->Datasource...)

 

 

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

recreating the report using the same login and directquery results in the same error as shown in the original post. When I use report->Manage->Datasource and set the authentication to Windows Authentication->As the user viewing the report (which is what we use throughout our organization), the connection tests successfully, but I still get the same error "We couldn't connect to the Analysis Services server..." as in the original post.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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