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.
I'm running into problems when using FI regional settings with dates. If I try to slice Direct Query dataset with dates (dd.mm.yyyy), I'm getting the error message below. Seems that the SQL query gets the datetime in wrong format?
If I switch the client reginal settings to US, everything works.
I'm not able to use date DAX-functions either with the direct query data. Without filtering or functions it also works.
Error Message:
110802;An internal DMS error occurred that caused this operation to fail. Details: Please use this Error ID when contacting your Administrator for assistance. EID:(3e14eb2919564915ab498a50575bcf3d)
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value. . The exception was raised by the IDbCommand interface.
User ID:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.