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 ...
Need Help
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
    6 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