Forum Discussion
Error to convert nvarchar to Datetime
Is your Date in SQL stored as NVarchar ? Also, share some sample data, may be just dates from SQL
Hi renanc
Could you show me the date format in SQL Database?
Maybe we need do some transformation for the date column.
There are some similar thread you could refer to
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is your Date in SQL stored as NVarchar ? Also, share some sample data, may be just dates from SQL
AnkitBI the issue was solved, the problem was indeed inside a SQL account view (the one linked in power bi) whose didnt have the correct datetime in english to portuguese.
In one of the sql accounts the table was loading properly, so we checked and converted to the same datetime and worked (that's why I said in SQL was ok, because indeed it was, but not in the one which was linked with BI).
Lol.. thank you guys, and sorry to waste your time, the whole issue was rooted in SQL.
