SQL Endpoint Metadata Sync Issue

[tolgakurt]

Hi,

I had a dim table that already existed in lakehouse and sql endpoint. I updated this table via pyspark (added new columns, removed some columns) and added it to lakehouse again with the same name in overwrite mode normally.

After doing this process, I can see the current table in lakehouse, but it is not reflected in sql endpoint and power bi semantic model sees the old version of the same table.

I deleted this table from lakehouse and added the same table again with a new name.

However, sql endpoint did not see it again. The strange thing is that when I write a query on the table that is not currently visible on sql endpoint, I do not encounter any error. After some research, I found a script that manually execute metadata sync and I ran it, but the result is still the same.

SQL Endpoint -> I deleted the dim_campaigns table from lakehouse and added a table with a different name, but dim_campaigns still appears in the sql endpoint.

This is the view in lakehouse. I can see dim_campaign_info here but not in the sql endpoint, but I can write queries on this table.

Can anyone help?

Thanks,

[v-prasare]

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[v-prasare · Accepted solution]

Hi @tolgakurt,

if your getting blocked, In this scenario if your blocked on this 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

[lbendlin]

this script? Fix SQL Analytics Endpoint Sync Issues in Microsoft Fabric – Data Not Showing? Here's the Solution! ...

[tolgakurt]

Yes. I was run this python script 2 -3 hour ago but not work.