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 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,

Chaithra.