Forum Discussion
Incremental Refresh - RangeStart - current value "Enter a DateTime value" error
I'm trying to set up an incremental refresh on one of my queries in PowerBI.
I've set up a new parameter called RangeStart - changed the type to Date/Time but whenever I try putting the Current Value in I keep getting an error message saying "Enter a DataTime value".
I've tried different formats dd/mm/yyyy hh:mm:ss:AM mm/dd/yyyy hh:mm:ss etc and I've tried similar formats to those listed on the Microsoft LEarn site and also from watching Youtube videos about setting this up - but no matter which format I use I still keep getting the same error message.
Can someone please let me know which date/time format I should be using to progress this?
Rob_Morris
12 AM should be in this format01/01/2022 00:00:00- Anonymous1 year ago
Hi Rob_Morris ,
Based on the testing, there is no problem with the current value of the date.
Try to check the date column data type.
You can view the following documents to learn more information.
Troubleshoot incremental refresh and real-time data - Power BI | Microsoft Learn
Configure incremental refresh for Power BI semantic models - Power BI | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- FowmySuper User
Rob_Morris
12 AM should be in this format01/01/2022 00:00:00 - AnonymousNot applicable
Hi Rob_Morris ,
Based on the testing, there is no problem with the current value of the date.
Try to check the date column data type.
You can view the following documents to learn more information.
Troubleshoot incremental refresh and real-time data - Power BI | Microsoft Learn
Configure incremental refresh for Power BI semantic models - Power BI | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.