Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Incremental Refresh Failure in Desktop for excel files

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 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

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

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

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

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

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