Forum Discussion
Fabric SQL Database SQL endpoint is not refreshing
Hey Royel ,
If the data is current in your Fabric SQL Database but the SQL analytics endpoint is not showing it, you are almost certainly hitting a metadata sync lag on the endpoint. You can trigger the sync programmatically using the Refresh SQL analytics endpoint metadata REST API. This works for SQL Database, Warehouse, Lakehouse, and mirrored items. But you can try the following workaround:
- In Fabric, go to your SQL Server item.
- Click the three dots (⋯) → select Open in VS Code.
- From the connection details, copy the Server Name and Database Name.
- In Power BI Desktop, create a new SQL Server connection using these details and refresh your data.
- Publish the updated report to the Power BI Service.
- In the Power BI Service, create a new connection using the same Server and Database names, and update the semantic model connection to point to this new SQL connection.
Best Regards,
Nasif Azam
Hi Royel ,
Thank you for explaining your scenario. Based on your description, it appears the SQL Endpoint isn’t syncing completely with your main Fabric SQL Database, even after using the Refresh button. This issue may occur if the metadata cache doesn’t update right away.
You can manually refresh the SQL Endpoint by using the official Fabric REST API, which forces the endpoint to sync with the database without relying on the UI refresh.
API endpoint:
https://api.fabric.microsoft.com/v1/workspaces/{workspaceId}/sqlEndpoints/{sqlEndpointId}/refreshMetadata
Helpful reference : Items - Refresh Sql Endpoint Metadata - REST API (SQLEndpoint) | Microsoft Learn
This API call initiates a metadata refresh and typically resolves problems where new data or changes aren’t showing up in the endpoint.
Additional helpful Reference:
Query the SQL analytics endpoint of your SQL database - Microsoft Fabric | Microsoft Learn
SQL Analytics Endpoint Performance Considerations - Microsoft Fabric | Microsoft Learn
I hope this helps.
Thanks for your response.
I tried with REST API, notebook but not solved. Its showing status 200 (ok) with all tables last sync status but actually endpoint data are not updating.
Hi Royel ,
Thank you for sharing your testing results. I understand how frustrating it can be when everything appears to sync correctly (status 200, timestamps look fine), but the data still doesn't update.
Since you've already tried refreshing via the UI, REST API, and notebooks, and the endpoint continues to display outdated data, there may be an underlying issue, such as a backend cache not clearing properly.
Here are a few suggestions that could help.
- Try making a minor schema change, like adding and then removing a dummy column. This can sometimes force a full refresh.
- If possible, recreate the SQL Endpoint and point it to the same dataset, which might resolve the issue.
- If you're using Direct Lake mode, check if there are any known limitations with real time syncing that could be causing this.
Please let me know if any of these steps help, and I’m happy to assist further if needed.
Regards,
Yugandhar.