Forum Discussion
How to limit the dataset during the development
- 6 years ago
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
parry2k how can I set the parameter value? I don't know the maximum number of rows of my dataset, it changes each day. For example, I know how to set it in order to mantain the first 1000 rows, but then, how can I set it in order to get all the rows?
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