Unable to connect to SQL Server using Report Server but is able to connect using Desktop

Thank you aduguid

Hi, jkl317 

Due to the Report server update, we get this error from you when uploading a report using a Directquery connection to the Report server:

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

PBI_SQL_TRUSTED_SERVERS

You can configure this property by following the tutorial below:

Press the Win + R key combination to open the Run dialog box. Enter sysdm.cpl and press Enter:

At this point, we need to add the PBI_SQL_TRUSTED_SERVERS as a user environment variable and a system environment variable:

Then restart your Report server:

After that, you can see your Directquery report normally.

The following case is a case that once discussed this issue:

Solved: Power BI report Server issue with Direct Query to ... - Microsoft Fabric Community

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.