cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

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 Azure SQL Server Database and all of my relationships are defined in Power BI.  The strange thing is that the error seems to come up fairly randomly.  I just clear the error, refresh the data in the .pbix file, and it is typically good to go until it loses the "model schema" again.  Does anyone else run into this issue or know what could be causing it?

 

Thanks,

 

Alex

7 REPLIES 7
Highlighted
Microsoft
Microsoft

Re: Couldn't load the model schema

Hi @alexhauge,

What's your version of Power Bi desktop? I personally suggest you download the latest version and check if the error dispears.

Thanks,
Angelia

Highlighted
Advocate I
Advocate I

Re: Couldn't load the model schema

Hi @v-huizhn-msft,

 

Unfortunately the version doesn't seem to matter.  I am currently running the July update and am still seeing the error.

 

Thanks,

 

Alex

Highlighted
Microsoft
Microsoft

Re: Couldn't load the model schema

Hi @alexhauge,

Please create a support ticket on the right bottom, and let the Product Group to check where the issue comes from.

Thanks,
Angelia

Highlighted
New Member

Re: Couldn't load the model schema

I get a similar issue when I do a direct connect to my SQLServer database.  I am able to connect to the DB, but PowerBI desktop kicks out an error when processing.  I can see the tables I selected on the "Relationships" view, but on the "Report" view I don't see any of the tables/fields in the "Fields" pane on the right.  I don't know if this is an issue with a configuration on the actual SQLServer instance I am hitting or not.  Funny thing is, when I hit the same database that is running on a MySQL platform rather than SQLServer, I can successfuly pull in model schema and then start building reports.  I have had this issue when using both the August and September updates of PowerBI.  Those are the only I have tried this on.

 

Any ideas?  

Highlighted
Regular Visitor

Re: Couldn't load the model schema

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

Highlighted
Regular Visitor

Re: Couldn't load the model schema

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'

Highlighted
Advocate II
Advocate II

Re: Couldn't load the model schema

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 Smiley Happy just like that

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.