Forum Discussion
incremental refresh - not available, parameters not showing in custom date filter
I found the error. the datefield must be date/time, not just Date.
Community SupportHi Anonymous,
Please ensure you already enabled the "Incremental Refresh Policies" preview feature in desktop.
Also please ensure the column you would like to set custom filter is Data/Time type. For more information, please refer to this article: https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
Best Regards,
Qiuyun Yu
I have enabled the incremental feature in preview features as mentioned.
I get the incremental refresh option when I right-click on the table, but it is off, and I can't enable it in the dialogbox. It says that I have to add paramaters to the dataset filter, but this has been done.
I have enabled the incremental feature in preview features as mentioned.
I get the incremental refresh option when I right-click on the table, but it is off, and I can't enable it in the dialogbox. It says that I have to add paramaters to the dataset filter, but this has been done.
this is how I have set it up
Added parameters
- sajidmansoorali
Helper I
after creating parameters you need to apply these parameter on any column of a sepecific table in query editor mode.
once done you will able to set incremental refresh on that specific table only.
