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...
Brief update:
Without changing anything on my end i tried again to load the above mentioned date (dimension) table into the data mart and i succeeded. Not sure whether there was a fix applied by MS?
I immediately added another (fact) table to the datamart so that i could create a relationship between the fact and dimension table. It did not work:( Unfortunately I am now stuck at this very stage. The error message is also not very helpful, either.