Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Couldn't load the model schema

Hello All,   I am receiving an error stating "Couldn't load the model schema" in Power BI Desktop when making formatting changes to my data model within Power BI Desktop.  My data source is an Azur...
Need Help
bshiaw's avatar
bshiaw
Regular Visitor
8 years ago

Hi all, 

 

I'm having the same issue and getting the 'Couldn't load model schema'.  

 

The strange thing this is an existing PBIX file (that was made a couple of months ago) with the same connection using DirectQuery works fine but when trying to create a new PBIX file with the same configurations/database/etc., I continually get this error message. I am using an Azure SQL database. 

 

The table data actually loads and I can view. However due to this error, I cannot actually use the data for any visualizations. 

 

This error consistently happens for me. Is there a setting/configuration that I need to configure? I am utilizing the latest PowerBI

  • bshiaw's avatar
    bshiaw
    Regular Visitor
    8 years ago

    We finally got it to work. 

     

    If for whatever reason you have the port number after your server address, remove it and it should work. 

     

    EX: Input 'coolpowerbi.database.net' instead of 'coolpowerbi.database.net:5454'

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      I created a dashboard with direct query connection two months ago, after I worked some dashboards with import connection but coulnd't reopen the direct query dashboards. I updated my Power BI to october 2017 version and it worked :smileyhappy: just like that