Fabric SQL Database SQL endpoint is not refreshing

[Royel]

Hi everyone,

I’m experiencing an issue with my Fabric SQL Database (SQL Endpoint).

Data appears correctly in the main SQL Database when:

• Previewing table data directly

• Running SQL queries

• Connecting through Power BI, SSMS, or Visual Studio

However, the SQL Endpoint is not showing the updated data when:

• Previewing table data

• Running SQL queries

• Connecting through Power BI, SSMS, or Visual Studio

What I’ve tried:

• Refreshed the SQL Endpoint multiple times using the Refresh button

Note:

I’ve already published a Power BI report connected through the SQL Endpoint. Since the report is deployed on the client side, it’s difficult to open a support ticket and resolve this internally.

Question:
Is there any notebook or script-based method to manually refresh or resync the SQL Endpoint with the main Fabric SQL Database?

Thanks in advance for your help!

[Nasif_Azam · Accepted solution]

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:

1. In Fabric, go to your SQL Server item.
2. Click the three dots (⋯) → select Open in VS Code.
3. From the connection details, copy the Server Name and Database Name.
4. In Power BI Desktop, create a new SQL Server connection using these details and refresh your data.
5. Publish the updated report to the Power BI Service.
6. 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

[Royel]

Thanks @Nasif_Azam this method helps. 

[V-yubandi-msft]

Hi @Royel ,

May I know if your issue has been resolved, or if you still need any additional details? Please let us know if you need any further assistance.
 

Thank you.

[V-yubandi-msft]

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.

[Royel]

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. 

[V-yubandi-msft]

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.

1. Try making a minor schema change, like adding and then removing a dummy column. This can sometimes force a full refresh.
2. If possible, recreate the SQL Endpoint and point it to the same dataset, which might resolve the issue.
3. 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.

[djurecicK2]

Hi @Royel ,

 Yes, you can refesh via the API- here is how to do it:

https://www.red-gate.com/simple-talk/blogs/sql-endpoint-secrets-you-need-to-know/

[Royel]

Thanks for your quick response, this method is suitable for Lakehouse or Warehouse (SQL Endpoint) not SQL Database. 

[djurecicK2]

Ok, I haven't tried that specifically with SQL database.

https://learn.microsoft.com/en-us/rest/api/fabric/sqlendpoint/items/refresh-sql-endpoint-metadata?ta...