Forum Discussion
How to limit the dataset during the development
Hi all,
I would like to know if there exists a smart way to limit the dataset rows during the development phase.
I am developing some reports over a dataset with trillions of rows and I want to develop them using a limited number of rows of the dataset. Once I'll publish the report on the server I want to switch to the full dataset.
Could someone suggest me how to do it?
Thanks in advance.
Hi SampaSim ,
If your underlying data contains a date column, perhaps you can create a time parameter. Please refer to https://community.powerbi.com/t5/Desktop/How-do-I-pass-parameters-to-my-SQL-statement/td-p/118716
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
3 Replies
- parry2k
Super User
SampaSim most common way is to create a parameter and based on the parameter value, limit the number of rows get loaded and once it is ready and published to the service, change parameter values in the service to load all the rows.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
v-deddai1-msftCommunity Support
Hi SampaSim ,
If your underlying data contains a date column, perhaps you can create a time parameter. Please refer to https://community.powerbi.com/t5/Desktop/How-do-I-pass-parameters-to-my-SQL-statement/td-p/118716
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
