Queries Disappeared for no reason

[Jie09]

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:

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!

[Anonymous]

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

[Jie09]

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