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

[seekrohit]

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

[arify · Accepted solution]

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