It would be nice to have the ability to dynamically create a Power Query to pull data from APIs or other workbooks.
I'd like to do something like this too, it would really make a killer application for our customers.
https://stackoverflow.com/questions/70655997/is-the-javascript-api-capable-of-creating-power-query-queries