Error Message

[Dannismen]

OLE DB or ODBC error: [Expression.Error] The Date operation failed because the resulting value falls outside the range of allowed values..

Can someone help me with this? 

[Anonymous]

Hi @Dannismen ,

It is suggested to try using local. 

Here are sample input values you can refer to.

Best Regards,

Stephen Tao

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

[amitchandak]

@Dannismen , seem like your date might have issues.  You might be using dd/mm/yyyy format or mm/dd/yyyy format and you are getting it in another format.

Usually this control by system setting

https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/...

or you can take it in text format and convert to date 

DD/MM/YYYY to MM/DD/YYYY
date(year( right(DD__MM__YY[date],4)), month(mid(DD__MM__YY[date],4,2)) ,day(left(DD__MM__YY[date],2)))

MM/DD/YYYY to DD/MM/YYYY
date(year( right(DD__MM__YY[date],4)), month(left(DD__MM__YY[date],2)),day(mid(DD__MM__YY[Version_Id],4,2)) )

[Dannismen]

Thanks for your reply but this date error never happened before. I just updated my data source which should only be the matter of total records. Even though I changed the setting to UK (I'm in US), still showed me the same error. Do you have other options?