Incremental Refresh - RangeStart - current value "Enter a DateTime value" error

[Rob_Morris]

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?

[Fowmy · Accepted solution]

@Rob_Morris 

12 AM should be in this format

01/01/2022 00:00:00

[v-jiewu-msft · Accepted solution]

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.

[Fowmy · Accepted solution]

@Rob_Morris 

12 AM should be in this format

01/01/2022 00:00:00