Forum Discussion

Barstool's avatar
Barstool
Regular Visitor
1 year ago
Solved

Underlying Error: Capacity operation failed with error code CannotRetrieveModelException

Hi

Trying to connect to a newly created semantic model from a new report in the Power BI service and receive:

 

"Underlying Error: Capacity operation failed with error code CannotRetrieveModelException"

 

I am able to connect to other semantic models using this method, but not this or a few others.  Checked the settings of the semantic models but cannot see any obvious differences.

 

Trying via the Power BI desktop, using OneLake Data Hub for the connection, I have similar issues.  Those semantic models I can connect to in the Power BI service open fine and list the tables in the Data Pane.  Those that give the above error message do not open in the Data Pane, and all that happens is that most of the options on the ribbon grey out, but no error message is presented.

 

Any help would be greatly appreciated.

Need Help
  • NikodemTesla's avatar
    NikodemTesla
    1 year ago

    Hi, 

     

    I got similar issue on my Fabric workspace and solution was to open SQL endpoint, then click on model layouts (i made some relations between tables but i guess it's not necessary for that specified purpose) and then in tab Reporting -> Automatically update semantic model 

     

8 Replies

  • NikodemTesla's avatar
    NikodemTesla
    New Member
    1 year ago

    Hi, 

     

    I got similar issue on my Fabric workspace and solution was to open SQL endpoint, then click on model layouts (i made some relations between tables but i guess it's not necessary for that specified purpose) and then in tab Reporting -> Automatically update semantic model 

     

  • pallavi_r's avatar
    pallavi_r
    Super User
    1 year ago

    Hi Barstool ,

     

    Please check this link.

    I resolved this by going to sql end point setting and turned on the sync to default semantic model.

     

    Thanks

    Pallavi

    • Barstool's avatar
      Barstool
      Regular Visitor
      1 year ago

      Thanks for your reply pallavi_r .

       

      I tried the suggested solution but unfortuantely it didn't resolve the issue:

       

       

      • SaiTejaTalasila's avatar
        SaiTejaTalasila
        Super User
        1 year ago

        Hi Barstool ,

         

        Is your source semantic model is composite model?(Is it getting data from any other semantic model)

         

        Thanks,

        Sai Teja 

  • Barstool's avatar
    Barstool
    Regular Visitor
    1 year ago

    Hi SaiTejaTalasila ,

     

    The semantic model isn't getting any data from any other semantic model.

     

    I'm connecting to Azure SQL server using a Data Pipeline and copying the tables into Delta Parquet tables.  All of the tables are from the same Azure SQL server database.

     

    Thank you

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Barstool, did you ever find a fix for this? I seem to be experiencing the exact same problem as you here 

    • Barstool's avatar
      Barstool
      Regular Visitor
      1 year ago

      Hi Anonymous .  I had numerous calls with Microsoft about this but a resolution wasn't found.  A workaround though was to simply recreate the semantic model and this worked.  So no rhyme or reason for the original issue, but I was able to continue with the new version.

      Hope this helps.