Forum Discussion
Incremental Refresh not working
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
8 Replies
Parameters must be datetime type, not date. Adjust in Power Query Editor.
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:
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.
Anonymous testing it, will update my results. I checked for trailing spaces and there were none.
Thanks
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
