GetPQ: A Very Bare-Bones Tool for Power Query

So a while back I was playing around with a Power Query Shared Library. I got pretty far, but I kept hitting walls in terms of how to put a cohesive tool together. I had ideas, but a lot of it really did not go together. It felt like after a bit that I was throwing stuff against the wall, so to speak.

I did get far enough and had something that could be helpful, but hit a wall because I couldn’t really think of how to extend something for Power Query that could not be done with other tools already out there. I mean, there probably could be things that would add value, but I am not sure what else would be helpful. Again, I don’t want to make something for the sake of making it, when something like Tabular Editor could do it easier.

Also, trying to really do anything with Power Query in Power BI Desktop was difficult (for me). Once I started playing around with SendKeys, I knew I probably was in trouble.

In any event, I cleaned up a few things on the PowerShell exe that I had put together and made a new GitHub release.

After installing, the tool would be an external tool in Power BI. It has 5 tabs:

1. Search the Power Query Library for functions and copy them to your clipboard. You can also open the associated Wiki for documentation.
2. Format your code using PowerQueryFormatter.com
3. Search PowerQuery.How
4. Open VS Code
5. Parse Power Query code and create parameters based on filepaths and URLs found in the code

The repo is here if you want to try it.