Incremental Refresh with Limited Data

Hey harib ,

unfortunately, it's not that simple, this is because of the initial load.

Basically, it's not possible to chunk existing data and load just a portion into Power BI Desktop and the remaining chunks will be loaded during the 1st load on the Service. Incremental refresh works exactly that way, but unfortunately, it's assuming that data is growing over time and not already there 🙂
If your workspace is backed by a premium license like P or Premium user this article might help you: https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla?WT.mc_id=DP-MVP-5003068

Please be aware that using advanced partition management requires some experience. If you are going down the road of partitions, it's also a good idea to start using the ALM-toolkit and Tabular Editor. Next to that separate your development into two pbix files one is used for the data model and the configuration of the incremental and the 2nd one is used for the development of the content: meaning your data visualizations.

The data source for the 2nd pbix file is the Power BI dataset created after publishing the 1st pbix file.

Hopefully, this adds some useful information.

Regards,

Tom