Forum Discussion
Prepaire a quit large dataset
Hi BF67 - we can use parameter-driven filtering for development to limit the row count.
some reference links for incremental refresh:
Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn
How to Load Large Datasets in Power BI Desktop Using Parameters | phData
Hope this helps.
Solution SageHi BF67
Incremantal refresh parameters are best wayt to limit the records for development. If you are not able to do in that way then there are couple of ways.
1. Add Top or Limit the number of rows and parameterize that in Power Query and change the value in service.
2. if you are using view then change the view definition, add filter during the development in desktop and change that definition (remove filters) once it is published to service.
Thanks
Hari