Forum Discussion
Incremental Refresh using Integer column
Hi All, I have dataset where it has id column and I want to set-up incremental data load using Power BI with Id column. CUrrently it is not supported and it supports only date column. Is there a...
Anonymous why not add a date column using this ID, like take a base date (like 2000-01-01 is a base date) and add this ID to that base date and use this new column for the incremental refresh.
You are going to use this column for incremental, otherwise, it has no value in the model. I think this will do it.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
The solution provided by amitchandak is working as expected. Thank you for your help.