- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
incremental refresh - not available, parameters not showing in custom date filter
Hi,
I'm trying out the new incremental refresh feature on a SSAS import datasource, but it's not available.
I Created the parameters RangeStart and RangeEnd, but when I try use them on the date column in the dataset, for custom filtering, they're not showing.
I am a premium user, I have updated to may build and I have activated the incremental refresh in options.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I found the error. the datefield must be date/time, not just Date.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I struggled with the same issue and found out the cause. You have to use both RangeStart and RangeEnd parameters and the parameter names have to be "RangeStart" and "RangeEnd" only.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Wow it's weird but working !
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you so much @sdesarda .
As you suggested, i gave same Parameter names. it worked for me .
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This worked for me..Thanks for the solution

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I was having the same issue but after I changed from direct query to Import, now I can set up the incremental refresh.
But I dont see it mentinoed as a requirement in the documentation here https://docs.microsoft.com/ja-jp/power-bi/service-premium-incremental-refresh
Does this only work for Import but not for direct query ?
That would really suck though
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes only work for Import Query
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous
'Direct query' queries the database and brings back all relevant data, so incrememntal refresh would not make sense.
Only when importing the entire table/source and adding in new data does it make sense
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Had some troubles, but this topic helped out. Date/Time format in the Query Editor was also my issue.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I found the error. the datefield must be date/time, not just Date.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
this is how I have set it up
Added parameters
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I already added the custom date filter, using the parameters I have created to the Date columns in the table (field is called dato). (See the printscreen I've added earlier).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
are you creating incremental refresh on the same table which has been filtered through custom filter. i.e. SSAS Leveransepunkt. because incremental refresh will not work on any other table which has not been filtered through custom filter with parameters.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am having the same issue.
Preview feature on, RangeStart and RangeEnd parameters defined on table, applied to Date/Time variable, but in the Incremental Refresh box for the same table shows the toggle as "off" with the warning showing that parameters need set up.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, @sdesarda
I am still facing this issue, please help!!
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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-21-2024 05:25 PM | |||
07-11-2024 10:27 AM | |||
04-23-2024 04:48 AM | |||
03-11-2024 10:49 AM | |||
Anonymous
| 01-12-2023 05:46 PM |
User | Count |
---|---|
141 | |
117 | |
80 | |
65 | |
47 |