It would be nice to have the ability to dynamically create a Power Query to pull data from APIs or other workbooks.
I second that!
I'd like to do something like this too, it would really make a killer application for our customers.
excel - Is the JavaScript API capable of creating Power Query queries? - Stack Overflow
This feature would open huge amount of opportunities. User would get benefit of powerful power query with simple click.
This is needed in order to switch over from VBA.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.