Power BI Report Server Connection to SQL Server Real-time Data Fails After Publishing

[changzhe]

Issue Description
When connecting Power BI Report Server to SQL Server real-time data, an error occurs after publishing:

Error Message
An unexpected error occurred. Please try again later.
Please try again later or contact support. If you choose to contact support, please provide these details.
Cannot connect to the Analysis Services server. Please ensure the connection string is entered correctly.
Request ID: 9852fabe-5d3c-cb4b-39dd-03ddf558f931
Time: Wed Mar 12, 2025, 09:58:57 GMT+0800 (China Standard Time)
Service version/powerbi/libs

Attempts Made
The connection to real-time data was configured correctly, and the data source connection test was successful.
The error appeared after publishing to the report server.

Inquiry
How can this issue be resolved? Appreciate any help!

[v-jianpeng-msft]

Hi, @changzhe 

You are using Direct Query mode and you need to follow the configured PBI_SQL_TRUSTED_SERVERS

Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn

Best Regards

Jianpeng Li

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