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:

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