Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
A colleague created a lakehouse called PAGP_Capitation, and I have Admin privileges on the workspace.
I created a Semantic model, and a Power BI report for this lakehouse.
This morning, a created 2 shortcuts to schemas in another lakehouse (in another workspace), and tried to update the Semantic model. I went in to edit mode, and clicked on Edit tables, and got the following error:
I opened up the SQL analytics endpoint, which said "We're loading your SQL analytics endpoint metadata".
I deleted the shortcuts, but got the same message in the SQL analytics enpoint.
I clicked on the refresh button at the top left of the screen, under "Home", and got this error:
The SQL query failed while running. Message=[METADATA DB] <ccon>(CODE:80002) The [dms$system].[DbObjects] appears to be corrupted (cannot find any definition of type 2)!</ccon>, Code=50000, State=0
How can I resolve this?
Solved! Go to Solution.
And it resolved itself over the weekend without any human intervention.
Hi @Liam_McCauley,
If your issue got resolved, then please consider Accept it as the solution to help the other members find similar transient issues more quickly
Thanks,
Prashanth Are
MS Fabric community support
And it resolved itself over the weekend without any human intervention.
Hi @Liam_McCauley,
According to the preview limitations of Lakehouse schemas, the SQL Analytics Endpoint and Semantic Model are among the functionalitites which are not supported in the current release of public preview:
Lakehouse schemas (Preview) - Microsoft Fabric | Microsoft Learn
In this scenario i suggest you to raise a support ticket here. so, that they can assit you in addressing the issue you are facing. please follow below link on how to raise a support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thanks,
Prashanth Are
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
Hi Prashanth,
I looked at that link, and I don't see where it says SQL Analytics Endpoint and Semantic Model are not supported. Can you tell me which line in the table says this, please?
In fact, this link explicitly tells you how to use Semantic Models with lakehouse schemas:
Lakehouse schemas (Preview) - Microsoft Fabric | Microsoft Learn
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
5 | |
3 | |
2 | |
2 | |
2 |