Forum Discussion

SSNAC's avatar
SSNAC
New Member
1 year ago
Solved

Power BI Report Server Error: Direct Query to SQL

Hi all, I’m uploading a Power BI report to the Power BI Report Server web portal. My report uses a DirectQuery connection to a SQL Server instance. Both the report server and the SQL Server are on-p...
DirectQuery2SQL
  • v-echaithra's avatar
    v-echaithra
    1 year ago

    Hi SSNAC ,

    Thank you for reaching out Microsoft Community.

    The issue is likely environment- or configuration-related within the server rather than with the report or the data source itself.

    Power BI DirectQuery reports must include "Encrypt=True;TrustServerCertificate=True" as part of the connection string on data sources, or apply the "PBI_SQL_TRUSTED_SERVERS" environment variable on their Power BI Report Server.

    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

     

    Regards,
    Chaithra E.

v-echaithra's avatar
v-echaithra
Icon for Community Support rankCommunity Support
1 year ago

Hi SSNAC ,

Thank you for reaching out Microsoft Community.

The issue is likely environment- or configuration-related within the server rather than with the report or the data source itself.

Power BI DirectQuery reports must include "Encrypt=True;TrustServerCertificate=True" as part of the connection string on data sources, or apply the "PBI_SQL_TRUSTED_SERVERS" environment variable on their Power BI Report Server.

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,
Chaithra E.