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
yravipudi
Frequent Visitor

Unable to open report from Power Bi Report Server May 2024

Hi Team,

we have a report with Direct Query Mode.

published the report to my report server.when i try to open the report server getting the below issue,

 

An unexpected error occurred
An unexpected error occurred. Please try again later.
ErrorDialogHelperText
Non-Windows user credentials were supplied for an non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting to Azure Analysis Services.: 
Request ID: 6ef6bfa9-b85f-3584-11d7-3af834b0d4e4
Time: Thu Jul 04 2024 14:06:25 GMT+0530 (India Standard Time)
Service version: /powerbi/libs

 

 

 

3 REPLIES 3
yravipudi
Frequent Visitor

Hi, @hackcrr 

Thank you for the quick reply,

my issue was not resolved. here i'm using SQL Server Database with Direct Query Mode for my report and if my report is import mode it is opening and used basic authentication to load the report from PBIRS

v-yohua-msft
Community Support
Community Support

Hi, @yravipudi 

Thanks for the reply from @hackcrr , please allow me to provide addition.

You can refer to the following links:

ssas - Error trying to use datasource in SQL Server Analysis Services - Stack Overflow

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

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

hackcrr
Solution Sage
Solution Sage

Hi, @yravipudi 

You need to ensure that the reporting server is configured to use Windows authentication. Verify that the credentials used to connect to Analysis Services are correct and have the required permissions.

Verify the report server configuration. View rsreportserver.config:
rsreportserver.config locates and opens the file on the reporting server.
Verify that the authentication settings for Windows Integrated Security are configured correctly.

 

hackcrr

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

 

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.

Top Solution Authors