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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Liam_McCauley
Frequent Visitor

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:

Liam_McCauley_0-1745484601931.png

 

I opened up the SQL analytics endpoint, which said "We're loading your SQL analytics endpoint metadata".

Screenshot 2025-04-24 094157.png

 

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:

Screenshot 2025-04-24 094217.png

 

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?

1 ACCEPTED SOLUTION
Liam_McCauley
Frequent Visitor

And it resolved itself over the weekend without any human intervention.

View solution in original post

4 REPLIES 4
v-prasare
Community Support
Community Support

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

 

 

Liam_McCauley
Frequent Visitor

And it resolved itself over the weekend without any human intervention.

v-prasare
Community Support
Community Support

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?

 

Liam_McCauley_0-1745931907393.png

 

In fact, this link explicitly tells you how to use Semantic Models with lakehouse schemas:

Lakehouse schemas (Preview) - Microsoft Fabric | Microsoft Learn

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

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 FBC25 Carousel

Fabric Monthly Update - June 2025

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