How to setup Advance Incremental Refresh

Hi Anonymous ,

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 Learn

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 Learn

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.