I have a web query which is expensive (time consuming) to run and I wish to return multiple processed tables (e.g. 3 tables) within the same query, and display the results to separate sheets?
Is this possible? The reason I don’t want to use separate queries is that there are overheads in each web query call, making it slow to run. Thank you
E.g.
let
Source = Excel.CurrentWorkbook(){[Name=”WEB_QUERY”]}[Content],
…
table1 = <>
Table2 = <>
Table3 = <>
in
Table1
Return multiple tables within same query
New contributor
Bella Grubb is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.