Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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.
Solved! Go to Solution.
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
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
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.
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
Thanks for your reply @pallavi_r .
I tried the suggested solution but unfortuantely it didn't resolve the issue:
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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
35 | |
21 | |
20 | |
15 | |
14 |