Can't access lakehouse SQL analytics endpoint due to can't view updated schema

[kirah2128]

I've already reached to our MS support and still not able to solve. I'm hoping someone from here have same experience and fix this issue.

[kirah2128 · Accepted solution]

DEAR ALL, 

The solution that works for me is to drop all the views and recreate them. For some reason, this works.

I'm also suspecting that the issue could be due to a view that joins multiple tables, and then I suddenly changed the column name of one of the tables, causing the problem.

I suggest you download your Lakehouse schema before dropping the views so you can copy the script to recreate them. I hope this solution works for you. It did for me.

regards,

King

[kirah2128]

Hi All,

here's the TRACKING ID and already escalated to MS team.

TrackingID#2406190050003587

Regards,

King

[v-cboorla-msft]

Hi @kirah2128 

Thank you for sharing the details.

[v-cboorla-msft]

Hi @kirah2128 

Thanks for using Microsoft Fabric Community.
Apologies for the issue you have been facing.

This might be an intermittent issue, It can take some time for the schema to refresh. So wait for sometime and then try to refresh the SQL endpoint. This will solve the issue.

Please refer to the thread in Fabric community, this might help you : Default dataset for Lakehouse not refreshing

Meanwhile could you please follow the below steps that might help you.

Temporary Glitch: Clearing cookies and caches can sometimes resolve temporary glitches within the application that might be causing the issue.

Corrupted Data: In rare cases, corrupted data stored in the browser's cache related to Microsoft Fabric might be causing the issue. Clearing the cache removes this potentially problematic data.

Hard Refresh: A hard refresh bypasses the cached version of the webpage and forces the browser to download the latest version from the server. Press Ctrl+Shift+R (Windows) or Cmd+Shift+R (Mac).

If you have reached to MS support team, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.

Thank you.

[v-cboorla-msft]

Hi @kirah2128 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.
In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.

Thank you.