Power BI Report Server Direct Query from Spark and SQL Server database is not working

Hi kitti ,

Thank you for reaching out to Microsoft Fabric Community.

As you have confirmed you have validated server names and also you have restarted the PBIRS service.

Please try the below steps as well.

• Go to Manage,  Data Sources, Set to Windows Authentication (Integrated),  Enable "Use as Windows credentials"

• Ensure ODBC or MSOLEDB drivers are installed on the PBIRS server for Spark/SQL Server.

• check for the report server logs in C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles , look for Errors related to DataExtension, OLEDB, Authentication, or AnalysisServices

• Use Power BI Desktop (Report Server version) from the PBIRS server itself to test connectivity using the same DirectQuery. This helps rule out firewall or driver-related issues or Make sure PBIRS can resolve and reach the SQL/Spark servers.

  Use ping, telnet <server> <port>, or Test-NetConnection.

• Go to Event Viewer,  Applications and Services Logs ,  Power BI Report Server and Look for errors tied to authentication or connection issues.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you!!

Hi kitti ,

Everything seems to be correctly configured as per your comments. 

Can you please raise a Microsoft support ticket for further investigation. You can create a Microsoft support ticket using the link below.

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Hope this works for you!

Thank you!!