- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 now I get the mashup error:
Any help would be very much appreciated!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It turns out... when I was clicking through the 'Connect to data destination' tool the default was 'New Table' which didn't show the Date to Date/Time mashup issue. When I went back through and realized 'New Table' was selected, I adjusted it to 'Existing Table' and then the mashup issue showed up.
Surprised me adjusting this in the SQL Endpoint model didn't fix this, but either way the original error was the actual issue! Thanks for the help and sorry for the time wasted!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Bdickers
Glad that your query got resolved.
Please continue using Fabric Community for any help regarding your queries.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Same result.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-03-2024 11:27 AM | |||
10-24-2023 03:36 AM | |||
02-06-2025 06:14 AM | |||
04-13-2024 10:00 AM | |||
11-10-2023 11:39 AM |
User | Count |
---|---|
3 | |
3 | |
1 | |
1 | |
1 |