excel - How to refer to other queries through "m" formulas or power query? -


the following line of code create variable of type table content table in spreadsheet.

instead of referring table in excel spreadsheets, want refer query. — how do that?

mytable = excel.currentworkbook(){[name="table_in_excel_spreadsheet"]}[content]

if query name text variable, use record.field(#shared, yourquery)


Comments