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 ,
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.
Thanks that worked! When I re-connected to the same original datasource/semantic model, it gave me the option to add more tables.
