Forum Discussion
Incremental Refresh on Sharepoint Excel (table) - Paramaters
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?
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
2 Replies
- amitchandakSuper User
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-HLFrequent Visitor
Excellent, thank you amitchandak