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 CannotRetrieveModelExce...
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 

     

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