Forum Discussion
JExcel1275
May 06, 2022Copper Contributor
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 inste...
- May 06, 2022
SergeiBaklan
May 06, 2022Diamond Contributor
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.
JExcel1275
May 06, 2022Copper Contributor
Do you know how I can still use the old Web query method?
- SergeiBaklanMay 06, 2022Diamond Contributor
- JExcel1275May 06, 2022Copper ContributorThank you