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...
Fully agree.
I stumbled upon something similar the first time when I used my own azure SQL Server as a temp storage to improve performance. for the first report ETL stage (with exports by R library (RODBC)) and reimported them to Power BI at 2nd stage. It could only store them sufficiently in SQL server when I transformed them into DTZ and then text. Already looked strange, but I thought its an R library issue.
In fact it seems here (and possibly the R issue above too) its a problem of the Azure SQL Server connector between Power BI and SQL Server on export to SQL Server. Microsoft technology to Microsoft technology 😂.
Hope they fix that soon.