Forum Discussion
Fabric SQL Database SQL endpoint is not refreshing (metadata sync lag)
Hi DKIDV,
Table count exceeds limit is the cause. It is not just a UI message. May be The issue is not caused by permissions or refresh problems the main reason your tables are missing in the SQL Analytics Endpoint is because your database has hit the internal table count limit. Once this limit is reached, the SQL Analytics Endpoint simply stops registering new tables, even though replication still shows as “Running” and the tables exist in the SQL Database. This is why older schemas appear while newer ones don’t, even when the tables are identical. The refreshMetadata API and small table changes won’t fix it because the endpoint is no longer accepting new metadata. The only real solutions are to reduce the number of tables in the database (drop unused or duplicate tables) or split your data across multiple databases using Fabric Pipelines to move data between them. This avoids the limit and ensures all tables become visible and sharable again.
Thanks & Regards,
Prasanna Kumar
Super UserHi DKIDV ,
Check if you have your permission correct in term of the different schema if you have access to all your tables.
When I started creating the SQLDB in fabric the table was not available in the SQL endppoint and then I add to create a role that had access to that table or schema.
https://learn.microsoft.com/en-us/fabric/database/sql/authorization
https://learn.microsoft.com/en-us/fabric/database/sql/authorization#sql-access-controls