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
Jie09
Frequent Visitor

Queries Disappeared for no reason

Some queries that I published and refreshed successfully in my Data Factory have disappeared for no apparent reason. Some of them are completely missing, while others have reverted to their initial status, as shown below:

 

Jie09_0-1719258619499.png

 

Since every query is loaded to the Lakehouse as output, I still have the tables intact in the Lakehouse, but the queries containing my code are gone! Does anyone know what is happening here? No one has touched my workspace. Thank you in advance!

 

2 REPLIES 2
v-heq-msft
Community Support
Community Support

Hi @Jie09 ,
According to your description, your query disappeared or reverted to its initial state without any apparent reason. You can troubleshoot this by doing the following:
First, if you are working in Power BI or Data Factory, there may be a version history that applies to the workspace. This can allow you to revert to a previous version where the query still exists.
Second, if the query is part of a data stream in Gen1, you can try migrating him to Gen2.
Finally, you can also utilize the Query Activity feature to view all running and historical T-SQL queries. This may give you insight into any long-running or frequently-running queries that may be affecting your workspace.
You can refer to the following information for more details
Move queries from Dataflow Gen1 to Dataflow Gen2 - Microsoft Fabric | Microsoft Learn
Access the Power BI activity log - Power BI | Microsoft Learn

 

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Hi Albert,

Thank you for your help! I'm indeed using Gen2 in Data Factory, but I don't know where to find the version history. Do you have any clue?

Best regards,
Jie

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI 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 Solution Authors
Top Kudoed Authors