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 
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's avatar
    ThomasRoulez
    Regular Visitor
    1 year ago

    Hello Anonymous ,

    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