Forum Discussion
Solved
How to choose connection over Power query
Hey there,
I have some Excel workbooks where I have used the web connection function to import data from an API which appear as per image 1.
Now if I try and set up new connections they instead default to queries which work but I am less familiar with the app, and for the sake of continuity would prefer to maintain using connections. As I try and add connections now they all appear under queries instead and I am unsure how to change the setup.
image 1:
image 2
4 Replies
Queries and connection are different things. If you load Table 0 query to data model it will have connection with it and appears as connection to ThisWorkbookDataModel.
Similar with external sources, most probably you have both query and connection.
- Do you know how I can still use the old Web query method?
