Forum Discussion

ThomasRoulez's avatar
ThomasRoulez
Regular Visitor
1 year ago
Solved

Issue Direct Query with Report

Hello Everybody, We have a PBIRS 2025-01 (Version1.22.9153.7886).  I create a report with a Direct Query connection to a SQL Server 2022. There is only 3 tables without relationship All works we...
Direct Query
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi ThomasRoulez 
    Thank you for reaching out to the Microsoft Fabric Community.

    If these solutions do not resolve the issue, please consider raising a Microsoft support ticket. 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

    If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.

    Thank you.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi ThomasRoulez 
Thank you for reaching out to the Microsoft Fabric Community.

Please try the steps below — they may help resolve the issue:

  1. Make sure Kerberos delegation is properly set up between your Power BI Report Server and SQL Server. This is required so the server can pass user credentials correctly when using DirectQuery.

  2. Double-check that the Service Principal Names (SPNs) are correctly registered for both the SQL Server and the Report Server service accounts.

  3. Confirm that the Report Server’s service account is trusted for delegation in Active Directory.

  4. Make sure you are building and publishing the report using the January 2025 version of Power BI Desktop for Report Server, as using an older version may cause compatibility issues.

  5. Check the Report Server logs for any detailed errors related to model loading — messages like “Failed to get CSDL” can help identify the issue.

  6. Keep in mind that the environment variable PBI_SQL_TRUSTED_SERVERS only helps in very specific scenarios and does not replace proper Kerberos configuration.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.

Thank you.