If I have an Excel workbook that is available online and this workbook contains a couple of spreadsheets and some Power Query M functions, is it possible to invoke these functions from another Workbook?
I know how to load the workbook with Excel.Workbook(Web.Contents("url"))
but this only lists the available spreadsheets and tables, but not the available functions.
My workbook is publicly available and I want to access the functions without special authorization.