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...
I have the exact same issue and same error message.
In my dataflow the datetime columns are being created via the datetime function of power M. So it should really be valid datetime. I also tried to add a regional scheme to the column in the data flow, but the 500 error persists.