Incremental Refresh not working

[bkan]

Hi All,

I have a table in the SQL Server database and I have a date field (DOS). I loaded the data from this table into PBI Desktop. I created 2 parameters RangeStart and RangeEnd ( set the values as 01/01/2024 and 01/01/2025) respectively. Clicked on close&apply. In the data pane right clicked and selected Incremental Refresh and I am getting the below message. Please advice

Thanks

[jay_patel]

@bkan  Please check datatype of your Date Column on which you are trying to apply incremental refresh.

[bkan]

@jay_patel Thanks. It is DATETTIME, both at the source and in the dataview.

[Anonymous]

Thanks for the reply from lbendlin , please allow me to provide another insight:

Hi,@bkan 

Could you please let us know if lbendlin's response resolved your issue? If it did, kindly accept it as the solution.

You may want to note that if there are issues with your parameter configuration, you might have overlooked the need to apply filters to the required columns. Below is a screenshot from the official documentation for your reference:

For further details, please refer to:

Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft...

Incremental refresh for semantic models in Power BI - Power BI | Microsoft Learn

 
Of course, if you have any new ideas, you are welcome to contact us.
 

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bkan]

@Anonymous testing it, will update my results. I checked for trailing spaces and there were none.

Thanks

[Anonymous]

Hi, @bkan 

Thank you for your swift response. I look forward to your updates and hope that our assistance proves effective for you.

Additionally, if you find our help beneficial, I would greatly appreciate it if you could accept our response as the solution. This would significantly contribute to the growth of our community.

Thank you in advance for your consideration. Wishing you a wonderful day ahead!

 
Of course, if you have any new ideas, you are welcome to contact us.
 

Best Regards,

Leroy Lu

[lbendlin]

Parameters must be datetime type, not date. Adjust in Power Query Editor.

[bkan]

@lbendlin thanks

still the same message. Is there some kind of feature that I need to turn on in the desktop?

[lbendlin]

Check the parameter names for trailing spaces .

Show the Power Query code where you use these parameters.