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.
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 see this is marked as solved, but please verify if this is a solution. Go to Power Query Editor, assuming the table is still there, right click the table and select "Enable Load"
Hi PowerBIAmature ,
This depends on the type of table you have and how you are pushing it to the model. If the table is bveing referenced or merged with another table what you refer is correct and your table get's disable the load.
However if it's a standalone table (from the power query perspective) that will get deleted from the model.
But very well observed.
Finally a direct solution. I had a single table, deleted it from the model view, and couldn't find a solution. This worked immediately. Thank you.
