Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I
Helper I

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 any alternative to this problem? The data set which I am using is a huge data with more than 35M and it will be difficult to load all the data everytime. Please let me know if anyone have solution for this.



Rajesh S Hegde

Community Champion
Community Champion

HI @hegdecisco86 

Incremental refresh works on the date column same as the datecolumn in your database.

Internally it fires the same query to refresh your dataset but uses an extra condition on where clause for date column on that table.

Hope you understand how it works then you will understand why it is not possible as per your requirement.


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile
Super User
Super User

@hegdecisco86 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, your one-stop-shop for Power BI-related projects/training/consultancy.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

The solution provided by @amitchandak is working as expected. Thank you for your help.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors