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!
Super UserCreate m parameters for your datasource. While you are sending them to your peers, fill these parameters with Test datasource connection. Ask your peers to publish them to power bi service with the same details. Once the dataset (semantic model) is published, you can open the dataset settings page and under the parameters section you will be able to find all the M parameters you would have created, modify them and enter the Prod datasource details. Then perform the data refresh. Then every one would be able to see the report with full set of data.
This is the common practice that everyone follows when they are handling large datasets.
Make sure you choose the M parameter datatype as Text. If you choose 'Any' then you will not be able to change its value from service.
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|