cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Remek1
Frequent Visitor

Incremental Refresh, multiple policy(?)

Hi Guys,

I'm wondering, are there any ways to configure multiple configurations on the SINGLE table?

 

So for example, I would like to refresh only the last say 1 day on weekdays and a full refresh during weekends?

I Heard this was an option on Analysis Services, but does PBI support something like this through Tabular editor/ DAX Studio or custom M?

Thanks,
Best

 

 

1 ACCEPTED SOLUTION
yingyinr
Community Support
Community Support

Hi @Remek1 ,

I'm afraid that there is no an elegant way to fulfill your needs. If you set incremental refresh for the dataset, there will be an initial refresh operation when you publish the corresponding report to Service. Partitions must be created, historical data loaded, objects such as relationships and hierarchies are built or rebuilt, and calculated objects are recalculated. But the subsequent refresh operations only refreshes the incremental refresh partition(s), so either individual or scheduled are much faster...

Incremental Refresh in Power BI, Part 1: Implementation in Power BI Desktop

All You Need to Know About the Incremental Refresh in Power BI: Load Changes Only

yingyinr_0-1655889474070.png

You can consider splitting the data into historical and current data in two separate tables on the data source side. Then configure schedule refreshes with different date period for these two tables (History table on weekends, current data table on full date period)...

yingyinr_1-1655889523047.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Hariharan_R
Solution Sage
Solution Sage

Hi @Remek1 

The default incremental configuration policy supports to create multiple partitions on single table. You can use Tabular editor to create different partitions using M code with different filter conditions.

 

Ref - https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla

 

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


My Blog :: YouTube Channel :: My Linkedin


Yes, but my question was more about how, how to schedule incremental refresh with X days during weekdays and full refresh during weekends in an automated fashion, 

Is that even possible?

 




yingyinr
Community Support
Community Support

Hi @Remek1 ,

I'm afraid that there is no an elegant way to fulfill your needs. If you set incremental refresh for the dataset, there will be an initial refresh operation when you publish the corresponding report to Service. Partitions must be created, historical data loaded, objects such as relationships and hierarchies are built or rebuilt, and calculated objects are recalculated. But the subsequent refresh operations only refreshes the incremental refresh partition(s), so either individual or scheduled are much faster...

Incremental Refresh in Power BI, Part 1: Implementation in Power BI Desktop

All You Need to Know About the Incremental Refresh in Power BI: Load Changes Only

yingyinr_0-1655889474070.png

You can consider splitting the data into historical and current data in two separate tables on the data source side. Then configure schedule refreshes with different date period for these two tables (History table on weekends, current data table on full date period)...

yingyinr_1-1655889523047.png

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors