cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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 2
Highlighted
Microsoft
Microsoft

Re: Connect to Oracle database schema not displayed

Hi,

 

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

Navigator should look something like this:

Untitled.png

 

Also, have you tried the search bar?

 

Thanks

Highlighted
Microsoft
Microsoft

Re: Connect to Oracle database schema not displayed

@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.

Capture.PNG

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors