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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.