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.

I found the error. the datefield must be date/time, not just Date.

incremental refresh - not available, parameters not showing in custom date filter

20 Replies

sdesarda
Advocate I
7 years ago
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.
- Anonymous
  Not applicable
  7 years ago
  Thank you so much sdesarda ! It works, finally :smileyhappy: It is a miracle :smileywink:
- Anonymous
  Not applicable
  7 years ago
  This worked for me..Thanks for the solution
- gsunilkumar145
  Helper I
  4 years ago
  Thank you so much sdesarda .
  As you suggested, i gave same Parameter names. it worked for me .
Anonymous
Not applicable
8 years ago
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
- Anonymous
  Not applicable
  8 years ago
  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
  - Anonymous
    Not applicable
    8 years ago
    I found the error. the datefield must be date/time, not just Date.
- Anonymous
  Not applicable
  4 years ago
  Yes only work for Import Query
v-qiuyu-msft
Community Support
8 years ago
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
- Anonymous
  Not applicable
  8 years ago
  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.
  - HRM5
    Frequent Visitor
    4 years ago
    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.
- Anonymous
  Not applicable
  8 years ago
  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.
  - Anonymous
    Not applicable
    8 years ago
    this is how I have set it up
    
    Added parameters
ribs
Helper I
1 year ago
How can you confirm if the incremental refresh is working? I have set the parameters and turned on incremental refresh in Power BI desktop and published to the service. Even then I see this error