Forum Discussion
Problem with date colum when staging
Hi, We were suffering exactly the same problem described by ArtecX
Problem appeared simply creating a dataflow gen2 using as source a table with a column with date type and a warehouse as destination. When executing the dataflow gen2 were were receiveing an error such below one
104100 Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: We can't update the table. The type of column 'FromDate' doesn't match the type of the column in the table.
We noticed that as ArtecX said for whatever reason the table created on the hidden artifacts has a datetime column instead of date as expected. This seems to be the root cause issue. Curiously we have created today the Dataflow from scratch and the issue does not longer appears.