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

For Oracle datasource how can i increase the default schema result to > 10000

For Oracle datasource how can i increase the default schema result to > 10000

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft
Microsoft

Re: For Oracle datasource how can i increase the default schema result to > 10000

Hi,

 

It's a UI issue, which is only able to show 10000 items in the navigator panel. Here's a work around:

 

Get Data > Blank Query > Advanced Editor

 

Copy this:

let
    Source = Oracle.Database("YOURORACLESERVER/YOURORACLESERVICE", [HierarchicalNavigation=true]),
    Schema = Source{[Schema="YOURSCHEMANAME"]}[Data]
in
    Schema

Let me know how it went 🙂

 

Thanks

View solution in original post

1 REPLY 1
Microsoft
Microsoft

Re: For Oracle datasource how can i increase the default schema result to > 10000

Hi,

 

It's a UI issue, which is only able to show 10000 items in the navigator panel. Here's a work around:

 

Get Data > Blank Query > Advanced Editor

 

Copy this:

let
    Source = Oracle.Database("YOURORACLESERVER/YOURORACLESERVICE", [HierarchicalNavigation=true]),
    Schema = Source{[Schema="YOURSCHEMANAME"]}[Data]
in
    Schema

Let me know how it went 🙂

 

Thanks

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors