Forum Discussion
Need Help ASAP!!! Dataflow Tables Gone!
- Anonymous1 year ago
Hi dbrandone ,
Thank you for posting in the Microsoft Fabric Community. Also thankyou GilbertQ for your inputs.When adding the new table, the existing queries were not retained in the Power Query editor, and saving the dataflow overwrote the previous 30 tables. Unfortunately, Power BI Dataflows do not have a built-in undo option, but there are a few ways you can attempt recovery.
First, you can try using the Power BI Scanner API to retrieve metadata, including the Power Query (M) scripts for your dataflow. This might help recover the lost queries, allowing you to manually recreate them. If your organization has audit logging enabled, you can also check the Microsoft Purview Compliance Center for recent modifications to the dataflow and possibly extract the previous structure.
If backups were taken in your Power BI workspace, restoring from a previous version might be an option.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thankyou.
Hi dbrandone ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.