Power Query Navigator not showing the all the Oracle tables

[buchnatasja]

Hello,

When I attempt to generate a new report by connecting to an Oracle database, I encounter a problem where I cannot see all the Oracle tables. However, I know that the tables exist because existing reports are functioning properly, and I can also observe them in Oracle SQL Developer. Additionally, Power Query is displaying an extensive list of tables, which seems excessive.

I suspect that this issue resembles a problem reported in 2014, which is described in the following blog post (Power Query Navigator not showing the correct number of items | Microsoft Power BI Blog | Microsoft ...).

This issue seems to have emerged after we updated to the October 2023 version.

[PijushRoy]

Hi @buchnatasja 

Looks you have multiple folder/group in Power Query, please check the query not showing other folder/group or sub-group

[buchnatasja]

No, I am 100% looking at the right folder.