Forum Discussion
Helper IVIssue with switching to a large dataset
Query folding depends on your datasource. If Keep Top rows step is folded then it wont read all the rows before restricting it to top rows. Even if it does not support you have work around you can use parameters to implement the restriction, instead of performing Keep top rows transformation.
Check out this thread for more information
https://community.fabric.microsoft.com/t5/Power-Query/How-to-Limit-rows-from-Oracle-source/m-p/4328861#M143252Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
Helper IVThank you. Another approach I was thinking about was to restrict the number of rows ingested from the datasource (Keep Rows), switch the data source and apply changes, then send the model to them and get them to publish after removing the Keep Rows condition. My questions was - when using Keep Rows, does PowerBI still need to first read in all the rows before restricting what we see, or does Query Folding mean it only actually ever reads in the number of rows that you specify? Thanks!!
- tharunkumarRTK
Super User
Query folding depends on your datasource. If Keep Top rows step is folded then it wont read all the rows before restricting it to top rows. Even if it does not support you have work around you can use parameters to implement the restriction, instead of performing Keep top rows transformation.
Check out this thread for more information
https://community.fabric.microsoft.com/t5/Power-Query/How-to-Limit-rows-from-Oracle-source/m-p/4328861#M143252Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!