Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Anonymous
Not applicable

we encountered an unexpected Error when opening a dataflow

Unable to open a dataflow for editing.

Get the Unexpected error

and the "In progress" Wheel at the Mashup Text

 

The Dataflow Refreshes and I Can Access the Data Through PBI Desktop. 

 

However, this error Prevents me from working on or editing the Query 

I was able to Export the Flow - An Inport it into a new Workspace - I get the same Error

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

I have discovered a Work Around

 

Instead of selecting Edit Tables (and getting the error) select Add Tables, add a Blank Query (power Query) you can then Save and It appears to restore Its self

 

you can then Go in and Delete your bank query Subsequently

View solution in original post

Anonymous
Not applicable

All Connections were to the gateway,

 

However I Too have not seen this reoccur in the last day or so - Seems Resolved 

View solution in original post

6 REPLIES 6
ChrisBurgessACT
Frequent Visitor

Looks like this has been resolved by MS.
No more unexpected errors. Nil code or environment changes this end.

ChrisBurgessACT
Frequent Visitor

I getting this too. Same workaround. 
But have to add table each time i want to edit the dataflow. So the workaround is not fixing the root cause.

Interesting in my case it appears to be 'erroring' when trying to open Dataflows that are not using a gateway (eg datasource https://api.powerbi.com/v1.0/myorg/admin/datasets), but happy to open/edit any dataflow that uses gateway.
Furthermore i can open/edit a gatewayless table dataflow by choosing one of the older table (queries) as entry point, rather than a newer (created) table as a entrypoint - no erroring.
So it appears to be affecting Dataflow tables created since last week where the dataflow does not use a gateway??
@Anonymous can you tell me your gateway/table scenario results?

Anonymous
Not applicable

All Connections were to the gateway,

 

However I Too have not seen this reoccur in the last day or so - Seems Resolved 

Anonymous
Not applicable

I have discovered a Work Around

 

Instead of selecting Edit Tables (and getting the error) select Add Tables, add a Blank Query (power Query) you can then Save and It appears to restore Its self

 

you can then Go in and Delete your bank query Subsequently

TomMartens
Super User
Super User

Hey @Anonymous ,

 

I recommend opening a support ticket with MSFT.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors