Incremental Refresh in Segments

[PowerBI123456]

Hi,

I have premium. Does anyone know if there is a way to bring over a large amount of data in segements with incremental refresh in dataflows? For example, I am trying to bring over account data from the last 3 months. Because its so much data and takes a while to load, I want to bring in one week at a time, is that possible?

[GilbertQ · Accepted solution]

Hi @PowerBI123456 

Unfortunately this is not possible, you have to put in the entire historical data that you want to load.

What I would recommend is to partition your data monthly, which will then query the data a month at a time. I explain this in my blog post here: How I changed the partition configuration (Year, Month, Quarter, Days) for my data in Power BI Premi...