cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DavidRPitts
Advocate II
Advocate II

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
DavidRPitts
Advocate II
Advocate II

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

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??
@DavidRPitts can you tell me your gateway/table scenario results?

All Connections were to the gateway,

 

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

DavidRPitts
Advocate II
Advocate II

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 @DavidRPitts ,

 

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
August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power BI Dev Camp Session 24 without aka link and time 768x460.jpg

Ted's Dev Camp - July 28, 2022

Watch Session 24 of Ted's Dev Camp along with past sessions!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors