Incremental refresh not working as expected

[HB13]

Hi all!

I have a query with regards to the incremental refresh settings.

I set an incremental refresh policy on one of my really large tables.

I archived data from the last 5 years (2017 - 2021) and set the refresh for the last 6 months which is currently 01/2022 - 06/2022. From my understanding the data stops changing/updating after  6 months

There has been changes to some of the data in my table during 04/2022 and new entries for 05/2022... but Power BI is not reflecting these changes even though this data would of been refreshed according to the 6 month refresh policy. 

For example:

Table in SQL shows this (data is what I expect in Power BI);
1. 04/2022     Policy1    0.00

2. 05/2022     Policy1    0.00
3. 04/2022     Policy2    0.00

4. 05/2022     Policy2    0.00

Power BI shows;
1. 04/2022     Policy1     3,000.12

2. 04/2022     Policy2     557.17                   

What am I missing? or what could be the issue?
Please advise

Many thanks!

[amitchandak]

@HB13 , Hope the changes can be caught using the date used in incremental?

In case you are having power bi premium, you can use SSMS to do a custom refresh if needed

XMLA Endpoint - Data Refresh using SQL Server Management Studio (refresh table/tables as per need): https://youtu.be/kyCnnpjOwpI

[HB13]

Thanks for your response!

I used a "createddate" column... it is DateTime. Would this impact the incrememtal refresh?

This workspace is Premium per User, but how does one automate a refresh via XMLA endpoint?