Forum Discussion
Power Query equivalent of PERSONAL.xlsb for queries, functions, etc.
Helper IThis does not exist unfortunately.
I built a VBA macro to copy queries from and to personal.xlsb. It is a bit of a hassle to setup, but it works for me.
I have also thought about using a seperate workbook to store all librray queries in a worksheet and load them in a powerquery record using Powerquery itself. Expression.Evaluate should be able to do the trick.
Assumming you name the record M, you could call each function or query as M[Your Query Name Here].
I did a proof of concept, but never finished it. Advantage over the VBA is that you always work with the lastest version. Downside is that it is a bit of a hassle to maintain....
- foodd
Community Champion
OMG., dufoq3 , thank you for sharing. And to this day, yes, jennratten is still Awesome 🙂
If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you. Proud to be a Super User!
- dufoq3
You're welcome. Enjoy 😉
- Keezz
Thanks! Also a good one! Easy to update.
I would extend it with puting all queries in a separate directory and automatically store all functions as separate fields in a record.
I only need to copy paste 1 query in all sheets with powerquery to boot strap the function loading process.
Anyone interested in the full solution? Then I will build it. Thanks for the link to the other post. Still wish this was something that was native to the Power Query platform, but this is a great alternative.
- dufoq3
😉
