Issue Direct Query with Report

[ThomasRoulez]

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 well in Power BI Desktop for Report Server (query retrieve data and visuals works well). 
I deployed report on server. 
When I try to open the report on the Server, there is the error message : 

When I go to Data Source all works well : 

We already add a enviornment variable PBI_SQL_TRUSTED_SERVERS on PBIRS with the SQL Server Source but nothing change.
Logs on PBIRS shows a szucessful connection (code 200) without any error.

Somebody can help me or have an idea to investigate ?
Kind Regards,
Thomas

[v-priyankata · Accepted solution]

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.

[ThomasRoulez]

Hello @v-priyankata ,
Yes we created a Microsoft support ticket and waiting a reply from them.

Thanks for your message

[v-priyankata]

Hi @ThomasRoulez

Thank you for confirming. I hope your issue gets resolved soon.

[v-priyankata]

Hi @ThomasRoulez 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[ThomasRoulez]

Hello @v-priyankata ,

Thanks for you message.
We check all yours points : 

• Delegation is correct
• SPNs are correctly registered 
• ReportServer Account Delegation is set on "Trust this user for delegation to any service"
• CSDL Error not found on logs

Issue is always there.
When we check the connection logs, we never see a connection to the SQl server.
The PBRIS doesn't seem to be able to open the report and therefore doesn't run any queries.
The issue when we open report is well "Cannot load the model".
The report is a new one made with PBI Desktop for report Server January 2025.

Do you know how to have more logs on PBRIS ? Maybe a verbose mode exists ?

KR and thanks a lot for your help,
Thomas

[v-priyankata]

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.

[ThomasRoulez]

New update :
With the upgrade to new version of Power BI Report Server (Version1.22.9153.7886(Janvier 2025)) reports with Import mode raise the same error "cannot load the model" and the connection test into Manage/Data Source works always well.
I'm going crazy 😛 

[ThomasRoulez]

Hi d_gosbell,

Thanks for the reply.
I think kerberos is well configure, because when I go to manage report/ datasource I can test connection and it's works well as you can see on my second screenshot.
Do you have any other idea ?
KR

[d_gosbell]

If the data source for your DQ queries is on a different server you will need to have kerberos configured in order to pass windows credentials. see Configure Kerberos to use Power BI reports - Power BI | Microsoft Learn