Forum Discussion

seekrohit's avatar
seekrohit
Regular Visitor
10 years ago

Connect to Oracle database schema not displayed

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

2 Replies

  • arify's avatar
    arify
    Microsoft Employee
    10 years ago

    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

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    10 years ago

    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.