Forum

Shifting between Lo...
 
Notifications
Clear all

Shifting between Loading Data in Table or in Connection

2 Posts
2 Users
0 Reactions
559 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: 4783
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:
0