Tables and Views not displayed in external tools.
Hello, we have experienced an issue regularly where Schemas and Business Schemas don't always show up in the list of available tables/views when listing the tables in an external tool like Dbeaver or Power BI.
We are still able to run a query against the tables that don't show up, but we haven't been able to figure out what causes the issue. It seems to happen randomly and to different schemas.
There are no issues with security, although revoking access to the schema and the granting it again sometimes resolves the issue.
This causes our Power BI published datasets to not automatically refresh because Power BI doesn't think the table exists.
Has anyone seen this behavior and/or know how to fix it?