Forum Discussion
Update many excel files Power Query Data sources
Hello, We have created a script using standard pivots tables and excel to update many excel files at once with a new DB connection with the script below (maybe this will be helpful to some!). Thi...
Hello paritysupport
interesting that such a program is written in Java instead of VBA.
the VBA-objects of Excel are used within the java-code. The problem is that there are no objects for Power Query and so I'm afraid there is no possibility create a automatism.
The only way I can think of is to create a table in your Excel-file, where you maintain parameters for you Queries. Then you use the programm to update this table and update the queries.
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy