Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Unexpected Error: Couldn't load the model schema

Upon trying to connect to an SQL Server database using DirectQuery, I encountered an Unexpected Error: Couldn't load the model schema. I had read some of the solutions such as removing the :port numb...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Frank, 

     

    The error has been resolved when the port number is entered after a comma behind the server name.

    servername, portnumber instead of servername: portnumber

     

    Regards

    Ryan

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous,

 

What is your vierson of Power BI desktop? Could you please update your power BI desktop and try again. Or you can refer to the blog to check gain.

 

Regards,

Frank

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Frank,

 

I am currently using Version: 2.61.5192.601 64-bit (August 2018). I will update my Power BI desktop and try again. 

 

Regards,

Ryan

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous,

     

    As the support page, that is a known issue. Engineers are working on a fix and expect it to be deployed to all regions by end-of-day 11/30/18. 

    https://powerbi.microsoft.com/en-us/support/

     

     

    Regards,

    Frank

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Frank, 

       

      The error has been resolved when the port number is entered after a comma behind the server name.

      servername, portnumber instead of servername: portnumber

       

      Regards

      Ryan

      • kv's avatar
        kv
        Icon for Advocate I rankAdvocate I
        7 years ago

        I am getting the same error when connecting to Oracle (v12) via Gateway. I have already tried deleting the connection cache under Global Permissions outlined in another post. 

         

        Cannot load model
        Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.
        Please try again later or contact support. If you contact support, please provide these details.

         

        Where would you make this change of comma/port, behind the server name?