incremental refresh - issue : skip the last day of the month

[Anonymous]

Hi,
I have set up my incremental refresh on the column date at the beggining of the year for a dataset in a dataflow. It stocks the last 10 years and it uptades the last month. But I just noticed that the incremental reshesh skip the last day of the month each time...  In consequence, I have my dataset with all my rows from 2013 to 2022 but for 2023 I have all my rows except the 31 january, 28 february, 31 march, 30 april, etc 
Does anyone know how to solve this ? 

[v-tangjie-msft · Accepted solution]

Hi @Anonymous ,

1.You need to check the data source settings and make sure the time zone is correct. You also need to check the refresh schedule and make sure it is not set to skip the last day of the month. You can also try to refresh the dataflow manually and see if the missing data is loaded.
2.You need to configure the incremental refresh policy correctly and make sure the RangeStart and RangeEnd parameters are set to include the last day of the month. You also need to make sure the date column in your source table has the Date/Time data type and matches the format of the parameters.

Please refer to the following documents for more information.

Incremental Refresh Partitions - Missing Data for ... - Microsoft Fabric Community

Configure incremental refresh and real-time data for Power BI datasets - Power BI | Microsoft Learn

Best Regards,

Neeko Tang

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