Incremental Refresh Failure in Desktop for excel files

[Anonymous]

Hi, 

I followed this documentation: https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh to create two incremental refresh parameters (RangeStart and RangeEnd, Type as Date). 

 

Then I applied the custom filter using these parameters in my data table. However, after close and apply query editor, the incremental refresh setting is still not giving me option to turn it on. 

Can someone please help with this issue? Not sure if incremental refresh only applies to relational database? My raw data source is a sharepoint folder with some excel spreadsheets. 

Appreciate the help in advance! 

Thanks,

Dennis 

[Greg_Deckler · Accepted solution]

@Anonymous - Make sure that your parameters are of type datetime. Your image shows that they are date.

[Anonymous]

Thanks @Greg_Deckler! I changed the data type to date/time and it works! I thought date data type would also work. 

[amitchandak]

@Anonymous , Check if datetime, or some other data type for the columns in the table. This issue is usually of a data type mismatch.