Incremental refresh on a non-technical column and escaping weekends

[AmiraBedh]

I have a table payment_trasaction in Power BI based on a simple SELECT from SQL Server
I configured the incremental refresh based on the Account Status date

between start_date and end_date which are the same 2/1/2024 00:00:00 AM (they are updated in the PBI service based on the refresh)

now when I check the config on it :
archive data starting from 10 years before refresh date
incrementally refresh data starting 31 days before refresh dare

no optional setting

the last time I refreshed the data set is 5/23/2024 and the Account Status date doesn't contain consecutive dates.

What do you think of the way the incremental refresh is configired?

when i check the table in power bi it has only data for may
but not for the months before
knowing that I skip the refresh for the weekends and the 

[Anonymous · Accepted solution]

Hi @AmiraBedh ,

Based on the description, an incremental refresh policy to partition the table, refreshing only the most recent import partitions, and optionally using another DirectQuery partition for real-time data can significantly reduce the amount of data that has to be refreshed. With incremental refresh, refreshes are faster and refreshes are more reliable.

For configuring policy, RangeStart and RangeEnd parameters are used to filter only a small period of data that’s loaded into the model.

In Archive data starting, specify the historical store period included in the model.

In Incrementally refresh data starting, specify the refresh period.

You can also view the following documents to learn more information.

Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft...

Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn

Troubleshoot incremental refresh and real-time data - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

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

[AmiraBedh]

I can't understand this part : optionally using another DirectQuery partition for real-time data

[AmiraBedh]

Since I am using Azure databases and not SSAS any workaround to check the partitions if possible ?