Forum Discussion
Error with SQL analytics endpoint after adding a shortcut to a schema in a different workspace
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?
4 Replies
Hi Anonymous,
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
Hi Anonymous,
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
