scottdk/Ninmonkey.PowerQueryLib

Custom functions for Power BI

Ninmonkey.PowerQueryLib

• Ninmonkey.PowerQueryLib
  • View Functions By Category
  • Exported Culture as Csv
  • New Usage
  • Importing External .pq files
  • Other projects
  • Functions
  • Other links
  • Usage ( Old version )
  • Language data

Custom functions for Power BI

View Functions By Category

• List Functions By Group.md 📌 ( Is new )

Exported Culture as Csv

• Table of Named DateTime FormatStrings by Culture.csv

New Usage

• This template loads any external pq file Template-Import-ninlib.pbix or Template-Import-ninlib.pq
• You can use it to load libraries like Ninmonkey.PowerQueryLib.pq or Write.Html.pq

Importing External .pq files

If you want to load your own .pq files, check out this function:

Import.PowerQueryLib.pq Or grab the pbix Template-Import-ninlib.pbix

If the script you load has any parsing errors it will show you extra information about the error. Which line, which error kind, uses xray to view nested Error Details fields, and more. Example error:

Reason: Expression.Error
Path: 75, H:\2024\tabular\2024.pq-lib.pq
Message: [75,9-75,11] Invalid identifier.
...
RemainingMessage:  Invalid identifier.
DetailsJson: 
    [{"Location":{"Kind":"Language.TextSourceLocation","Text":"","Range":
     {"Start":{"Line":74,"Column":8},"End":{"Line":74,"Column":10}}},"Text":"Invalid identifier."}]
...
Context: 
        Format.Csv = Csv,
        23

Other projects

• answering forums: ninMonkQuery Example
• OscarValerock/PowerQueryFunctions
• tirnovar/m-custom-functions
• tirnovar/Power-BI-Admin-REST-API-Connector and tirnovar/Power BI REST API using Power Query

Functions

Categories: Values • Types • Expressions • Comparer • Functions

• Functions - Top Level
• useful functions from the Custom Connector Docs - microsoft/DataConnectors/Helper Functions
• OAuth Authentication
  • first read: blog.crossjoin Connecting To Rest APIs with OAuth2 in Power BI
• Windows Authentication and SSO
• Implementing Table.Schema - Custom Connectors - bengribaudo.com

Other links

• Custom Connector tutorial: TripPin

• DataConnectors / samples

• Power Query M Language Specs

• Details on Web.Contents: Special Behavior of HTTP Status Codes

Usage ( Old version )

1. Open your report and open test_All.pbix
2. Select the functions you want (Any dependencies will be included for you)
3. Copy -> Paste

Language data

• All PowerQuery Functions
• All PowerQuery Constants
• All *.Types This contains all built-in types like: Int64.Type, Currency.Type, etc.