Forum Discussion
Helper IIHow can I add a new table to my Power Query, using an exsisting connection?
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
3 Replies
- jdbuchanan71
Super User
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_pThanks 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
