Incremental Refresh on Sharepoint Excel (table) - Paramaters

[Gary-HL]

Hi All, 

I am trying to setup an incremental refresh on a table within a sharepoint excel file. I have parameters RangeStart and RangeEnd setup, yet the incremental refresh setup screen still mentions parameters and options are greyed out. I have referenced these direct in the query to the table (possibly not needed or wrong?). Referenced paramters in filter - "#"Filtered Rows" = Table.SelectRows(#"Changed Type1", each [Date] >= RangeStart and [Date] <= RangeEnd)"

Please see screenshots.

I have a Pro license.

Any ideas why the option to setup the incremental refresh is not working. Thanks.

Any Ideas?

[amitchandak · Accepted solution]

@Gary-HL , Make them datetime and add a filter in your table

Power BI Incremental Refresh Pro; Premium Deployment pipeline - https://youtu.be/nIxTRdeCYSE

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh

[Gary-HL]

Excellent, thank you @amitchandak