Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Error message: Couldn't load the model schema associated with this report.

Hi Community, 

I am attempting to use Direct Query to connect to an on prem SQL Server with a very simple SQL statement.

The report looks like this in the Power BI Desktop and uses a table, a text filter and slicer visuals (attached).  The number of rows returned on the SQL query is about 5,000.

I published the report to the Power BI Services (we have Premium workspace) and I'm getting this error (attached).  

 

 

 

My gateway connection to the SQL Server is good and I have the permissions needed on the database.

Any more thoughts on troubleshooting?

 

Thank you!

Michelle

Need Help

3 Replies

  • collinq's avatar
    collinq
    Icon for Super User rankSuper User
    6 years ago

    Hi Anonymous ,

     

    If this is a Direct Query sometimes you have to ADD (or sometimes, REMOVE) the port number on the SQL server connection.  Other things to confirm are that the Gateway (or Premium connection strings) and the Power BI Desktop that created the file are up to date.  

     

    If that doesn't fix it, then you should try to run a trace (FIddler for example) and see where the block is happening.

     

    I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks collinq , let me use your suggestions and see if that works! 😁

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi again,

        Just circling back to let you know that I haven't solved this issue, so I'm going to Power BI support.  Will advise what I find for the community!

        Michelle