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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
coverturfLSH
Helper I
Helper I

Dataflow Gen2 failing because of deleted query

Hi,

 

I created an issue for myself and am wondering if anyone else has experienced the same issue with a solution.

 

  1. I have a Dataflow Gen2 that has multiple queries that publish to a datahouse data destination.
  2. One of the queries started failing because the underlying source changed a column name
  3. I decided I no longer needed this query/data and deleted the query from the dataflow
    1. The query still had an error that I did not fix (mistake 1?)
    2. The query still had a data destination that I did not remove (mistake 2?)
  4. Even though the query is deleted from the dataflow, the entire dataflow is still failing because it is still trying run the deleted query. Specifically erroring out on the "writetodestination" step.
  5. When I export the json for the dataflow, I can still see the query I had deleted.
  6. I waited a day because sometimes there's a caching thing I've noticed with PowerBI, but still getting the failure today.

Just curious if anyone else has run into this issue and what they did to resolve?

I'm not planning on submitting a Microsoft ticket because every time I do for an issue they just tell me to delete and recreate which I may have to do. It would be really nice if they allowed an import of the json model like you can with dataflow gen1. 

 

Thanks in advance,

1 ACCEPTED SOLUTION

Thanks cboorla. I was able to resolve the issue by recreating the deleted query in the dataflow. I used the exact same query name and data destination settings and it worked. 

View solution in original post

3 REPLIES 3
v-cboorla-msft
Community Support
Community Support

Hi @coverturfLSH 

 

Thanks for using Microsoft Fabric Community.
At this time, we are reaching out to the internal team to get some help on this.
We will update you once we hear back from them.

Appreciate your patience.

 

Thanks

Thanks cboorla. I was able to resolve the issue by recreating the deleted query in the dataflow. I used the exact same query name and data destination settings and it worked. 

Hi @coverturfLSH 

 

Glad that you were able to find some insights and thank you for sharing the same with the community as it can be helpful to others.

Please continue using Fabric Community for further queries.

 

Thanks

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

MayFBCUpdateCarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

Top Solution Authors