Forum Discussion
Adding back deleted tables connected via DirectQuery Power BI semantic model
Hi LostintheBIu ,
Yes, there is a way to re-add the table from your Direct-query source-
1. Go to Transform Data--> Data Source Setting
2. Select the Direct query source you need --> Select Change Source
After selecting that, a dialog box will open from which you can select the table you want to load.Additionally, you can refer these solutions
https://community.fabric.microsoft.com/t5/Desktop/Adding-another-table-from-an-existing-semantic-model-in-a-hybrid/m-p/4271107
https://community.fabric.microsoft.com/t5/Desktop/Direct-Query-add-tables-after-initial-setup/m-p/337401
Hope this helps!
If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.
Hi LostintheBIu - Once you connect to a semantic model in DirectQuery mode and delete a table, there's no obvious UI option to re-add just that table without breaking your model or relationships.
option1: you can re-add a deleted table from your semantic model
you can go to the Model view in Power BI Desktop>>On the left side (in the Fields pane), right-click on the dataset/semantic model name>>Choose "Add tables" (if available).
This will allow you to browse and select the tables you previously did not include, including the one you deleted.
This option only works if the semantic model was connected using DirectQuery and the Power BI Desktop still maintains the connection metadata. It won’t duplicate your connection—it just brings the missing table back in.
Option2: Reconnect Cleanly and Keep It All Together
I cannot see the options you are referring to in option1, as my fields pane is on the right-hand side of the screen, but thank you for taking the time to reply.
