Hi @Kieran-q_20
The issue where not all schemas, particularly a specific schema containing a view, are displayed in PowerBI when connecting to a database is not uncommon. This could be due to a variety of reasons, ranging from permissions issues to the way PowerBI caches metadata. Here are some steps and considerations to troubleshoot and potentially resolve this issue:
Permissions: The most common reason for not seeing a specific schema or view in PowerBI is related to permissions. Ensure that the user account used to connect to the database from PowerBI has the necessary permissions to access the schema and the view. Sometimes, database roles and permissions are set in a way that restricts access to certain objects.
Database-Level Roles - SQL Server | Microsoft Learn
Refresh Metadata: PowerBI caches the metadata of the database schemas and objects it connects to. If the view was recently added or the schema was changed after PowerBI last refreshed its cache, it might not show up. Try refreshing the data source in PowerBI to update the cached metadata. In Power BI Desktop refresh of report visuals, data refresh, and schema refresh all happen together using. In the Power BI service Schema refresh not available.
Here is a link about data refresh where you can learn more details about refresh:
Data refresh in Power BI - Power BI | Microsoft Learn
Direct Query vs. Import Mode: If you're using DirectQuery mode, try switching to Import mode (or vice versa) to see if that makes a difference. Sometimes, the mode in which PowerBI connects to the database can affect the visibility of certain database objects.
Database Compatibility: Ensure the database and specific schema are fully compatible with PowerBI. Although PowerBI supports a variety of databases, some databases may not fully support certain features or configurations.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
