Forum Discussion

Royel's avatar
Royel
Super User
9 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 ...
Need Help
Tips and Tricks
  • Nasif_Azam's avatar
    Nasif_Azam
    9 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