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
m_cherriman
Advocate I
Advocate I

Old Query still included in data flow run

I have a Dataflow which includes two queries one for products and one for mosaicdata.  There used to be a third query called customers but I deleted it.  However, when I run this Dataflow it fails (see fig 2) and it still references the customer query which seems to succeed at the initial level and then failes when it tries to write the data to a table, presumably because there is no data to pull back.  Has anyone else encountered this issue?

fig 1

m_cherriman_0-1699455706243.png

fig 2

m_cherriman_3-1699456036373.png

 

 

 

1 ACCEPTED SOLUTION
m_cherriman
Advocate I
Advocate I

After spending some time with one of the team at Microsoft we were able to resolve the issue by disabling the Enable Staging option for both queries.  After doing this and publishing the data flow the Customer query was no longer in the json file and the query ran.

 

m_cherriman_0-1699601532348.png

 

Hope this helps.

View solution in original post

5 REPLIES 5
m_cherriman
Advocate I
Advocate I

After spending some time with one of the team at Microsoft we were able to resolve the issue by disabling the Enable Staging option for both queries.  After doing this and publishing the data flow the Customer query was no longer in the json file and the query ran.

 

m_cherriman_0-1699601532348.png

 

Hope this helps.

Hey! If you raised a support ticket, would you mind sharing that support ticket here? We would love to better understand this case.

miguel
Community Admin
Community Admin

Hi!

If you try to refresh the dataflow once again, do you still get the same customers table showing up in the refresh history screen?

If yes, please reach out to the support team by creating a support ticket: https://support.fabric.microsoft.com/support

 

They'll primarily be looking for the .json file of your Dataflow to see if there are still references to the customers query in it.

miguel_0-1699456552662.png

If a discrepancy exists where the reference exists in the .json file but you do not see that query when you try to edit the dataflow, then they'll investigate further to see what could be the issue. However, if it happens that when you click on edit you still see the "customers" query then that might be a different issue that they'll be looking into as to why it might be happening and why you are not able to delete that query.

 

Thanks Miguel,

 

The Dataflow still fails and shows the customer query as failing.  It's also referenced in the json file, but not visible in the query edit view.  I'll raise a call and update the post when I get an answer.

Hi m_cherriman - Kindly checking whether you got a chance to file a Support Ticket and you could share the ID with us.

 

We'd love to take a deeper look into this issue but require DataflowID and other telemetry information to do so, which we would get through the Support case.

 

Thanks,

M.

Helpful resources

Announcements
FabricCarousel_June2024

Fabric Monthly Update - June 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Kudoed Authors