Connect to Oracle database schema not displayed

[seekrohit]

From Power BI, i was able to connect to the Oracle Database, however my schema does not show up as the list of schemas is very long. The tool lets you scroll only a certain number of schemas. Beyond which it does not let you scroll.

Also when i try to search my schema, it does not show up.

Is there a way to increase the number of schemas it can display ?

Thanks

Rohit

[Eric_Zhang]

@seekrohit

I was not aware there's such a limitation to show a certain number of schemas, may I know how many schemas in your case and what is the certain number?

By the way, have your checked the option "Navigate using full hierarchy"? And use SQL statement to query data instead of selecting on the schema lists if the limitation is not avoided.

[arify]

Hi,

Can you please show us a screenshot of the navigator? Do you have more than 10000 schemas?

Navigator should look something like this:

Also, have you tried the search bar?

Thanks