Incremental refresh not enable

[naivecalf]

Hi,

I am trying to use incremental refresh, setup two parameters and fields with datetime format, but still can not enable, any ideas?

[amitchandak]

@naivecalf , check the datatype of the parameter it should be DateTime.

check these for reference

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-...
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-...

[Anonymous]

Hi @naivecalf 

Incremental refresh has limitations on only some DBs, doesn't work on all of them.

Please go through the document throughly before making it as an option.

https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only

[naivecalf]

@Anonymous ,

thanks for replay, I tried excel table and sharepoint online list, looks they are not supported.

Regards

Steven

[naivecalf]

Hi, tried sharepoint online list again, it is working now. just make sure the field is data/time, not date. thanks.

[Anonymous]

Hi @naivecalf 

PBI team is working on expanding it but right now only hand full of MS Db are supported

[naivecalf]