Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
LostintheBIu
Helper I
Helper I

Adding back deleted tables connected via DirectQuery Power BI semantic model

Hi everyone,

 

I have a Power BI report, which is connected to a Power BI semantic model in DirectQuery mode. When I initally made the report, I deleted all the dimension tables that I did not need (just to clean up the report building view). Unfortunately now I realise that I need one of the dimension tables that I deleted. However I cannot find the option to edit which Power BI semantic model tables are being loaded. And I cannot just click Get Data and add the Power BI semantic model again just for this one Dimension table, because the table loads in DirectQuery mode, and therefore Power BI will not allow me to connect this table to the other data tables, even though all the tables are from the same Power BI semantic model, just loaded at different times.

 

Is there are hidden option where I can edit which tables being loaded in when connected via DirectQuery Power BI semantic model?

 

Thanks for any assistance.

1 ACCEPTED SOLUTION
v-sdhruv
Community Support
Community Support

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

Shruti_D_0-1744358791919.png


2. Select the Direct query source you need --> Select Change Source

Shruti_D_1-1744358852740.png
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-mod...

https://community.fabric.microsoft.com/t5/Desktop/Direct-Query-add-tables-after-initial-setup/m-p/33...

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.

View solution in original post

4 REPLIES 4
v-sdhruv
Community Support
Community Support

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

Shruti_D_0-1744358791919.png


2. Select the Direct query source you need --> Select Change Source

Shruti_D_1-1744358852740.png
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-mod...

https://community.fabric.microsoft.com/t5/Desktop/Direct-Query-add-tables-after-initial-setup/m-p/33...

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.

rajendraongole1
Super User
Super User

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





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.

Helpful resources

Announcements
Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.

"); $(".slidesjs-pagination" ).prependTo(".pagination_sec"); $(".slidesjs-pagination" ).append("
"); $(".slidesjs-play.slidesjs-navigation").appendTo(".playpause_sec"); $(".slidesjs-stop.slidesjs-navigation").appendTo(".playpause_sec"); $(".slidesjs-pagination" ).append(""); $(".slidesjs-pagination" ).append(""); } catch(e){ } /* End: This code is added by iTalent as part of iTrack COMPL-455 */ $(".slidesjs-previous.slidesjs-navigation").attr('tabindex', '0'); $(".slidesjs-next.slidesjs-navigation").attr('tabindex', '0'); /* start: This code is added by iTalent as part of iTrack 1859082 */ $('.slidesjs-play.slidesjs-navigation').attr('id','playtitle'); $('.slidesjs-stop.slidesjs-navigation').attr('id','stoptitle'); $('.slidesjs-play.slidesjs-navigation').attr('role','tab'); $('.slidesjs-stop.slidesjs-navigation').attr('role','tab'); $('.slidesjs-play.slidesjs-navigation').attr('aria-describedby','tip1'); $('.slidesjs-stop.slidesjs-navigation').attr('aria-describedby','tip2'); /* End: This code is added by iTalent as part of iTrack 1859082 */ }); $(document).ready(function() { if($("#slides .item").length < 2 ) { /* Fixing Single Slide click issue (commented following code)*/ // $(".item").css("left","0px"); $(".item.slidesjs-slide").attr('style', 'left:0px !important'); $(".slidesjs-stop.slidesjs-navigation").trigger('click'); $(".slidesjs-previous").css("display", "none"); $(".slidesjs-next").css("display", "none"); } var items_length = $(".item.slidesjs-slide").length; $(".slidesjs-pagination-item > button").attr("aria-setsize",items_length); $(".slidesjs-next, .slidesjs-pagination-item button").attr("tabindex","-1"); $(".slidesjs-pagination-item button").attr("role", "tab"); $(".slidesjs-previous").attr("tabindex","-1"); $(".slidesjs-next").attr("aria-hidden","true"); $(".slidesjs-previous").attr("aria-hidden","true"); $(".slidesjs-next").attr("aria-label","Next"); $(".slidesjs-previous").attr("aria-label","Previous"); //$(".slidesjs-stop.slidesjs-navigation").attr("role","button"); //$(".slidesjs-play.slidesjs-navigation").attr("role","button"); $(".slidesjs-pagination").attr("role","tablist").attr("aria-busy","true"); $("li.slidesjs-pagination-item").attr("role","list"); $(".item.slidesjs-slide").attr("tabindex","-1"); $(".item.slidesjs-slide").attr("aria-label","item"); /*$(".slidesjs-stop.slidesjs-navigation").on('click', function() { var itemNumber = parseInt($('.slidesjs-pagination-item > a.active').attr('data-slidesjs-item')); $($('.item.slidesjs-slide')[itemNumber]).find('.c-call-to-action').attr('tabindex', '0'); });*/ $(".slidesjs-stop.slidesjs-navigation, .slidesjs-pagination-item > button").on('click keydown', function() { $.each($('.item.slidesjs-slide'),function(i,el){ $(el).find('.c-call-to-action').attr('tabindex', '-1'); }); var itemNumber = parseInt($('.slidesjs-pagination-item > button.active').attr('data-slidesjs-item')); $($('.item.slidesjs-slide')[itemNumber]).find('.c-call-to-action').attr('tabindex', '0'); }); $(".slidesjs-play.slidesjs-navigation").on('click', function() { $.each($('.item.slidesjs-slide'),function(i,el){ $(el).find('.c-call-to-action').attr('tabindex', '-1'); }); }); $(".slidesjs-pagination-item button").keyup(function(e){ var keyCode = e.keyCode || e.which; if (keyCode == 9) { e.preventDefault(); $(".slidesjs-stop.slidesjs-navigation").trigger('click').blur(); $("button.active").focus(); } }); $(".slidesjs-play").on("click",function (event) { if (event.handleObj.type === "click") { $(".slidesjs-stop").focus(); } else if(event.handleObj.type === "keydown"){ if (event.which === 13 && $(event.target).hasClass("slidesjs-play")) { $(".slidesjs-stop").focus(); } } }); $(".slidesjs-stop").on("click",function (event) { if (event.handleObj.type === "click") { $(".slidesjs-play").focus(); } else if(event.handleObj.type === "keydown"){ if (event.which === 13 && $(event.target).hasClass("slidesjs-stop")) { $(".slidesjs-play").focus(); } } }); $(".slidesjs-pagination-item").keydown(function(e){ switch (e.which){ case 37: //left arrow key $(".slidesjs-previous.slidesjs-navigation").trigger('click'); e.preventDefault(); break; case 39: //right arrow key $(".slidesjs-next.slidesjs-navigation").trigger('click'); e.preventDefault(); break; default: return; } $(".slidesjs-pagination-item button.active").focus(); }); }); // Start This code is added by iTalent as part of iTrack 1859082 $(document).ready(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); $("#tip2").attr("aria-hidden","true").addClass("hidden"); $(".slidesjs-stop.slidesjs-navigation, .slidesjs-play.slidesjs-navigation").attr('title', ''); $("a#playtitle").focus(function(){ $("#tip1").attr("aria-hidden","false").removeClass("hidden"); }); $("a#playtitle").mouseover(function(){ $("#tip1").attr("aria-hidden","false").removeClass("hidden"); }); $("a#playtitle").blur(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); }); $("a#playtitle").mouseleave(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); }); $("a#play").keydown(function(ev){ if (ev.which ==27) { $("#tip1").attr("aria-hidden","true").addClass("hidden"); ev.preventDefault(); return false; } }); $("a#stoptitle").focus(function(){ $("#tip2").attr("aria-hidden","false").removeClass("hidden"); }); $("a#stoptitle").mouseover(function(){ $("#tip2").attr("aria-hidden","false").removeClass("hidden"); }); $("a#stoptitle").blur(function(){ $("#tip2").attr("aria-hidden","true").addClass("hidden"); }); $("a#stoptitle").mouseleave(function(){ $("#tip2").attr("aria-hidden","true").addClass("hidden"); }); $("a#stoptitle").keydown(function(ev){ if (ev.which ==27) { $("#tip2").attr("aria-hidden","true").addClass("hidden"); ev.preventDefault(); return false; } }); }); // End This code is added by iTalent as part of iTrack 1859082
Top Solution Authors