Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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.
I found the error. the datefield must be date/time, not just Date.
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.
Wow it's weird but working !
Thank you so much @sdesarda .
As you suggested, i gave same Parameter names. it worked for me .
This worked for me..Thanks for the solution
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
Yes only work for Import Query
@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
Had some troubles, but this topic helped out. Date/Time format in the Query Editor was also my issue.
Thanks
I found the error. the datefield must be date/time, not just Date.
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
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
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.
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).
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.
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.
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.
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.
User | Count |
---|---|
90 | |
88 | |
86 | |
79 | |
49 |
User | Count |
---|---|
151 | |
143 | |
111 | |
74 | |
55 |