cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.

 

Thanks,

Rajesh S Hegde

1 ACCEPTED SOLUTION
Super User IV
Super User IV

@hegdecisco86 , refer if this can help

https://www.fourmoo.com/2020/03/11/how-to-configure-incremental-refreshing-in-power-bi-with-datekey-...



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

4 REPLIES 4
Super User II
Super User II

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.





PBI_SuperUser_Rank@1x.png
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 III
Super User III

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






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.

Super User IV
Super User IV

@hegdecisco86 , refer if this can help

https://www.fourmoo.com/2020/03/11/how-to-configure-incremental-refreshing-in-power-bi-with-datekey-...



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

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

Top Solution Authors
Top Kudoed Authors