Dataflow Gen2 failing because of deleted query

[coverturfLSH]

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,

[v-cboorla-msft]

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

[coverturfLSH · 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. 

[v-cboorla-msft]

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