Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
@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
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)) )
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |