Forum Discussion

Bdickers's avatar
Bdickers
Frequent Visitor
2 years ago
Solved

Dataflow Gen2 Mashup Error

I connect to a sharepoint folder housing multiple excel spreadsheets that I combine using this Dataflow. I just moved those sheets to a subfolder (and adjusted my Dataflow to account for that) and no...
Dataflows
Need Help
  • miguel's avatar
    miguel
    2 years ago

    based on the error message shown in the screenshots, it appears that you have a mismatch of data types between your old mashup document and the new one that happens for a column that has datetime and it expects a date column instead. More information is provided in the error message.


    what happens when you try to publish your mashup document? Do you get any sort of error message when trying to publish? Or is it only during a refresh operation ?

Bdickers's avatar
Bdickers
Frequent Visitor
2 years ago

Thanks for the response Miguel! I double checked the column mapping and the data columns are all 'Date' types being mapped to 'Date' types.

 

 

 

Just to see if it made a difference, I went to the SQL Endpoint and changed the table field's type from 'General Date' to a specific Date format that does not include times. Same result. I may go ahead and publish to a new endpoint to see if that fixes it. 

Bdickers's avatar
Bdickers
Frequent Visitor
2 years ago

Same result.