It would be nice to have the ability to dynamically create a Power Query to pull data from APIs or other workbooks.
4 Comments
This is needed in order to switch over from VBA.
This feature would open huge amount of opportunities. User would get benefit of powerful power query with simple click.
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
I second that!
