I have been attempting to create a Data Flow that loads a spreadsheet from my One Drive folder. The excel file has:
1. A column with unique ID
2. Column names have spaces in them (and sometimes a leading or trailing space, which causes a Publish failure)
I am able to create the dataflow, map the fields to a New Table, identify the column with a unique id (text field with just an incremental whole number (1,2,3...). Then I click Publish. This completes and I am watching the status from the Data Flow list page. Finally, the publish fails. It has been a column name with a trailing or leading space. I fix the field name. That's when errors start cropping up.
1. On the map columns screen, new table is still selected, BUT the unique field is no longer selected properly.
2. I update the unique field reference.
3. Click "Publish" nothing happens.
On further digging, there is a javascript failure. I am attaching a screenshot. The screen is now broken and the data flow cannot be republished. I have to delete and start over.
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2