Hi, I am trying to add dataflows to a datamart, however when loading up the data to the datamart, I am getting an error that my date column is not a valid date/time field. Please see error belo...
Status changed:
Investigating
to Investigating
Currently as far as my test, the datamart could load columns correctly when I tested it in my side.
Although I have create a datetime column with M function, it could also be loaded correctly:
The Local column is created by DateTime.FixedLocalNow() function.
So it looks like a regional issue, not a global issue since someone has worked already, someone has not.
Perhaps you can try to create a new test datamart with the same dataflow in different workspaces to check this issue again. If it still has the same issue and it is urgent for you, you can create a support ticket here at the end of the page for further fast investigating.
Best Regards,
Community Support Team _ Yingjie Li