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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors