Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Barstool
Regular Visitor

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.

1 ACCEPTED SOLUTION
NikodemTesla
New Member

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 

NikodemTesla_0-1743494023305.png

 

View solution in original post

8 REPLIES 8
NikodemTesla
New Member

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 

NikodemTesla_0-1743494023305.png

 

msaville
Frequent Visitor

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

Hi @msaville .  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.

Barstool
Regular Visitor

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

pallavi_r
Super User
Super User

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.

pallavi_r_0-1729875236476.png

 

Thanks

Pallavi

Thanks for your reply @pallavi_r .

 

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

 

Barstool_0-1729888721672.png

 

Hi @Barstool ,

 

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

 

Thanks,

Sai Teja 

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Kudoed Authors