This project offers a collection of functions and useful queries for Power Query Formula Language (also known as M language) and a loader to import source code from external modules into Power Query.
Download the contents of this repo and extract it anywhere you want. If
you skip this step you will not be able to list all available modules with
LibPQ()
call and every time you load a module LibPQ will access the network.
Create two blank queries in your workbook:
Import any of the available modules via LibPQ("modulename")
when writing your
queries in Advanced Editor.
To import all modules available locally use LibPQ()
with no arguments (or
null
). That will return a record where keys are module names and values are
the results of loading those modules (function object or output of a query).
All modules are grouped into namespaces, much like the standard library:
Detailed module list is available in documentation, and each module has a clear description in the comment at the top of its source file.
LibPQ allows specifying multiple possible locations for source code, that's why you can add @tycho01's library as a fallback.
Any module from that library should be supported, though some will require
adding a Load
query to your workbook. To create a Load
alias for LibPQ
you need to:
LibPQ
Load
Now the Load
function will be available from #shared
context, and you
should be able to import any module from @tycho01's library.
All contributions are welcome! Please check CONTRIBUTING.md for details
GitHub's issue tracker is the primary venue for asking and answering support questions. Please don't forget to search closed issues for the topic you're interested in!
If you know an answer to the question asked by someone else, please do not hesitate to post it! That would be a great help to the project!
If for some reason you'd rather not use the issue tracker, contacting me via email is OK too. Please use a descriptive subject line to enhance visibility of your message. Also please keep in mind that support through the channels accessible to the public is preferable because one answer can help many people who might read it later.
My email is visible under the GitHub profile and in the commit log.
You might get faster and more interactive support from other users.
This project does not (yet) have a dedicated community venue, but experienced PowerBI/Power Query users will most likely be able to figure out most common questions. You can try asking at the local PowerBI-related forums, Facebook groups, IRC/Discord/Telegram chats or on Reddit/StackOverflow.
Copyright © 2017-2021 Vitaly Potyarkin
Licensed under the Apache License, Version 2.0 (the "License");
you may not use these files except in compliance with the License.
You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.