Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
For Oracle datasource how can i increase the default schema result to > 10000
Solved! Go to 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
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