web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : 2cPgENFiyqIQCtbwV/MmCl
Power Apps - Power Query
Unanswered

Failed Data Flow Publish continues to fail after error is fixed

Like (0) ShareShare
ReportReport
Posted on 8 Apr 2024 19:42:29 by

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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Featured topics

Loading complete