Tables are not showing up in Azure data studio

Question

had Power BI connected through an Azure database, and it was working fine previously. However, the refresh recently failed. When I checked the database in Azure Data Studio, the only table I could see was one named "Dropped Ledger." I'm not sure what caused this, and it appears that all other tables are missing or inaccessible.

Answer 1

Hi @ Luke Manthuruthil

It seems there has been a significant change on the database side. If you only see a single table ("Dropped Ledger") and the other tables are missing in Azure Data Studio,

Here are a few steps to help troubleshoot and potentially recover access to the missing data:

Sometimes, metadata tools like the object explorer don’t show everything. Try this:

SELECT name, type_desc
FROM sys.objects
WHERE type_desc = 'USER_TABLE';

If this returns nothing, then user tables might have been dropped, or you're not seeing them due to schema changes.

Sometimes tables can be moved under a different schema. Run:

SELECT TABLE_SCHEMA, TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE';

This will show all user-accessible tables across all schemas.

If Power BI refresh failed and now you can't see the data, it's possible the data source schema changed.

Check Power BI error messages — they might give more clues (e.g., "table does not exist", "invalid schema", etc.).

Hope this helps. Do let us know if you any further queries.

---

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.