Forum Discussion

Royel's avatar
Royel
Super User
10 months ago
Solved

Fabric SQL Database SQL endpoint is not refreshing

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!

Need Help
Tips and Tricks
  • Nasif_Azam's avatar
    Nasif_Azam
    10 months ago

    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

9 Replies

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support
    10 months ago

    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's avatar
      Royel
      Super User
      10 months ago

      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's avatar
        V-yubandi-msft
        Community Support
        10 months ago

        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.

  • Nasif_Azam's avatar
    Nasif_Azam
    Super User
    10 months ago

    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

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support
    10 months ago

    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.