Power BI Navigator not showing all Oracle tables - SQL Developer shows them

[B92]

Environment:
- Power BI Desktop: 2.153.910.0 64-bit (April 2026, MSI version)
- Oracle Database: 12.1
- Windows 11 Home
- Oracle Client: OCMT 64-bit installed

**Issue:**
When connecting to Oracle ERP database, Power BI Navigator shows only some tables. However:
- ✅ SQL Developer (with same credentials) shows ALL tables
- ✅ Direct SQL query works: `SELECT * FROM table_name`

**What I've tried:**
- Cleared local cache (%localappdata%\Microsoft\Power BI Desktop\AnalysisServicesWorkspaces)
- Set MaxEvaluationWorkingSetInMB registry to 4096
- OCMT 64-bit reinstall
- "Display Options" only shows "Only selected items" and "Enable data previews" - NO "All schemas" option
- ODAC installed, TNS_ADMIN set

The connection works, but Navigator is not fetching complete schema metadata.

Any help would be appreciated!

[v-ssriganesh]

Hello @B92,

We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.

Thank you.

[v-ssriganesh]

Hi @B92,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to @Lodha_Jaydeep for sharing valuable insights.

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

Thank you for being part of the Microsoft Fabric Community.

[Lodha_Jaydeep · Accepted solution]

Hi @B92,

Thanks for reaching will happy to assist.

There was similar issue reported earlier also. I am attaching the link. Please have a look if it can helps.

https://community.fabric.microsoft.com/t5/Desktop/SQL-Data-Source-Does-not-show-all-tables/td-p/2970... 

https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-Navigator-not-showing-the-all-the-...

Documenation for the Oracle DB connection steps:
https://learn.microsoft.com/en-us/power-query/connectors/oracle-database