Share via

Text to Date type conversion Error

Majumder, Manish 136 Reputation points
2022-01-28T11:42:37.26+00:00

Hello,

Greetings,

I am facing below error while trying to convert text values to Date Type in AAS Tabular Model transformation . The DB is Azure SQL

169437-error.jpg

Could you please suggest how to resolve the issue?

Azure Analysis Services

Answer accepted by question author

Sander van de Velde | MVP 37,061 Reputation points MVP
2022-01-28T12:06:07.427+00:00

Hello @Majumder, Manish ,

the datetime format is strange, that comma is not expected...

Could you test this again where the comma is left out? Or, try a format which is ISO compatible?

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.