How can I add a new table to my Power Query, using an exsisting connection?

[steen_p]

Hi,

Being fairly new to Power BI and Power Query, I'm struggling with adding additional tables to my model. I have created a connection to my datawarehouse and selected a Fact and some dimension tables. That's all good, but how do I then add some more tables using the connection I have already made? In the Power Query editor I can see that I can right click and choose "New Query", but then I have to start all over again by selecting a source type and enter details for the source etc. 

Maybe it's just me that are over looking the obvious, but I assume there must be a simple way to simply add more tables to the model I've already made?

Regards

Steen 

[jdbuchanan71]

@steen_p 

The easiest way I have found is to make a copy of one of your smaller queries that links to your source then change the navigation step on the new query to point to the new table you want to add and finally rename the table.

[steen_p]

Thanks for the feedback, but actually I found the solution myself :-).

I have a "Recent Sources" drop-down on he Home menu in Power BI, and here I can select my source in the drop-down and then I can select the tables/views I'd like to add. That's pretty much what I was looking for, but I don't know why I didn't find that in the first place.

Regards

Steen

[Icey]

Hi @steen_p ,

Glad to hear that. Please accept your reply above as a solution so that people who may have the same question can get the solution directly.

Best Regards
Icey