Forum

Shifting between Lo...
 
Notifications
Clear all

Shifting between Loading Data in Table or in Connection

2 Posts
2 Users
0 Reactions
56 Views
(@vsoler)
Posts: 1
New Member
Topic starter
 

Hello Mynda,

 

If I have loaded and created a Table for my PowerQuery, can I, later on, change it to a Connection?

And alternatively, if a Connection is created, can I change it to a Table?

 

It seems as though those two shifts are not possible. Are there any workarounds?

 

Best regards

 
Posted : 01/05/2018 2:30 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Vicente,

Yes, you can change the load settings in the Query pane on the right-hand side of the Excel window. Select the query > right-click > Load to.

Mynda

 
Posted : 01/05/2018 7:23 pm
Share: