How to setup Advance Incremental Refresh

[maryambarr_96]

Hi All, 
I just want to confirm, to use of advanced incremental refresh in PBI.
1. Do we need to set up incremental refresh first?
2. Can we set up incremental refresh without having any date column in Fact_Table?

thanks in advance

[v-junyant-msft · Accepted solution]

Hi @maryambarr_96 ,

About your first question:
Yes, you need to set up incremental refresh first. About how to set up, you can refer to this document:
Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft...

And your second question:
In general, you must have a data column of data type date/time to configure incremental refresh. However, if your tables don't have a column of date/time data type but instead have a date column of integer surrogate keys in the form of yyyymmdd, you can configure it by means of data conversion Incremental Refresh. Please refer to this link:

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

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