Forum Discussion
Incremental Refresh
Hi Guys,
I am using incremental refresh in PBI. First of all i have created two parameter RangeStart and RangeEnd and then provide filter in date column. then i try to turn on Incremental Refresh toggle button by right click on that table but not able to turn on. Why?
i am attaching all the related screen short
Anonymous
Parameter type should be Date/Time. Not Date.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos πHere is my latest blog
https://community.powerbi.com/t5/Community-Blog/Dynamic-Page-Navigation-Based-on-User-Login/ba-p/1097786
2 Replies
- nandukrishnavsCommunity Champion
Anonymous
Parameter type should be Date/Time. Not Date.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos πHere is my latest blog
https://community.powerbi.com/t5/Community-Blog/Dynamic-Page-Navigation-Based-on-User-Login/ba-p/1097786 - amitchandakSuper User
Anonymous , check data type you date column and date type of parameter. refer if these can help
Incremental Load
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
https://thinkaboutit.be/2020/02/how-do-i-implement-an-incremental-refresh-in-power-bi-free-or-pro/
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.nabler.com/articles/power-bi-data-refresh-and-scheduling/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
https://www.fourmoo.com/2020/03/11/how-to-configure-incremental-refreshing-in-power-bi-with-datekey-or-date-instead-of-the-default-datetime/