Forum Discussion

sean_w's avatar
sean_w
Frequent Visitor
5 years ago
Solved

Power Query equivalent of PERSONAL.xlsb for queries, functions, etc.

Problem: I often find that I want or need to reuse a Power Query function or approach in one Excel workbook that I've used in a previous Excel Workbook, without the hassle of "reinventing the wheel"...
Need Help
Tips and Tricks
Tutorial Requests
  • dufoq3's avatar
    dufoq3
    2 years ago

    You can store your functions/queries in text file. Check this.

dufoq3's avatar
dufoq3
Icon for Community Champion rankCommunity Champion
2 years ago

You can store your functions/queries in text file. Check this.

Keezz's avatar
Keezz
Icon for Helper I rankHelper I
2 years ago

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.