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 for your advice. It is much appreciated. Just one question - what if we do not want them to see our Test Data - ie we would prefer them not to connect to our Test Data set?
- tharunkumarRTK
Super User
In that case, you can publish the semantic mondel on your own. If you do not have permissions to publish it to the actual workspace then you can publish to a test workspace or a Personal workspace (My Workspace) and change the parameter values and perform the data refresh and then share the report with them.
Or if you want you can download the report and share it with them as a attachment
Need 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!