Forum Discussion

HB13's avatar
HB13
Icon for Helper I rankHelper 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 - 20...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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
    Icon for Helper I rankHelper 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?