How to choose connection over Power query

[JExcel1275]

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

[#2]

@JExcel1275 

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.

[#3]

Do you know how I can still use the old Web query method?

[#4 · Accepted solution]

@JExcel1275 

[#5]

Thank you