Forum Discussion
Post PartisanIncremental Refresh in Segments
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?
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 Premium / Power BI Premium Per user! - Reporting/Analytics Made easy with FourMoo and Power BI
1 Reply
- GilbertQ
Super User
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 Premium / Power BI Premium Per user! - Reporting/Analytics Made easy with FourMoo and Power BI