Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Accidentally deleted table from Model View

Hi,    I wanted to delete a certain relationship between two tables but instead a complete table was deleted. I marked the relation with the mouse and used the "delete key" to remove it . I see no ...
General Comment
  • MFelix's avatar
    MFelix
    5 years ago

    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.

PowerBIAmature's avatar
PowerBIAmature
New Member
3 years ago

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"

fercele's avatar
fercele
New Member
2 years ago

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.