Forum Discussion

HB13's avatar
HB13
Helper I
4 years ago

Incremental refresh not working as expected

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!

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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's avatar
      HB13
      Helper I
      4 years ago

      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?