Skip to content

tnclark8012/Power-BI-Desktop-Query-Extensions

master
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?
Code

Latest commit

 

Git stats

Files

Permalink
Failed to load latest commit information.
Type
Name
Latest commit message
Commit time
 
 
 
 
 
 

Extension Functions for Power BI Desktop and Excel

PBI Desktop (and Excel 2016) Query Functions that you can use to make life easy-peasy. Submit issues or pull requests for functions you'd like to see added. Most functions are self-documenting, and new documentation is being added all the time.

Getting Started

1. Create a blank query

New Blank Query

2. Open the advanced editor

AdvancedEditor

3. Paste in the library

Option 1: Always get the latest from GitHub - Requires data privacy considersations

Copying the below will give you the latest versions and all times. You can connect with anonymous credentials. Be sure to set the data privacy level appropriately when prompted.

Expression.Evaluate(Text.FromBinary(Web.Contents("https://raw.githubusercontent.com/tnclark8012/Power-BI-Desktop-Query-Extensions/master/power-query-extensions.pq")),#shared)

Option 2: Copy the current version locally - No issues with data privacy

Copy paste the contents from https://raw.githubusercontent.com/tnclark8012/Power-BI-Desktop-Query-Extensions/master/power-query-extensions.pq

AdvancedEditor

4. Name the query something short and sweet (like "PBI")

5. Click on function names to see documentation!

Create

6. Use it by referencing PBI[TheFunctionName]

Before:

Create

After:

Create

Contributing

The more the merrier! Be sure to document your function and include a test

About

Various M Queries that you can use to make life easy-peasy

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published