Forum Discussion
Queries Disappeared for no reason
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
- Jie092 years agoFrequent Visitor
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