Forum Discussion
Accidentally deleted table from Model View
Hi Anonymous ,
You are correct about the behaviour, if you want to delete the relationship you need to rigth click the relationship.
Also be sure to read the pop up menu that confirms what you are deleting.
For sure you also do this but I always do a save before doing a change in a relationship or delete a table, that way if I do any mistake I can just close and reopen the file.
Maybe you can post an idea on the ideas part of the forum to get the relationship selected when you click and not the table.
I am surprised that Power BI professionals say that there is no solution and if there is, what they must do is go to transform data, they look for the table that they deleted by mistake and on the right side where the applied steps appear remove the deletion step, it worked for me to recover a column of the table, I imagine it must be the same for a complete table
Hi Stivens_Agudelo ,
When you delete a column there is an additional step that is added to your power query, that is why you can go back to your query and just delete that step and return to the previous state. However when you delet a table you are deleting the query itself not just adding a step to your query.
There is no option to revert an accidental delete of a table.