Power BI and Power Query Resources

You can copy a single query, or select them all to save all queries!
If the query has dependencies, they are automatically copied!
You can paste into another PBI report or a text editor.

VS Code: Power Query Addon

get the VS Code: Power Query Addon

SQL Native queries

Passing Parameters To SQL Queries With Value.NativeQuery() In Power Query And Power BI

[blog.crossjoin.co.uk] Chris shows how to use Parameterized Native SQL queries

let
    Source = Sql.Database("localhost", "Adventure Works DW"),
    Test = Value.NativeQuery(
        Source,
        "SELECT * FROM DimDate 
        WHERE EnglishMonthName=@MonthName",
        [
            MonthName = "March",
            DayName = "Tuesday"
        ]
    )
in
    Test

docs Value.NativeQuery()

Performance

Guidance for using DirectQuery successfully [docs.microsoft.com]
Monitor Report Performance [docs.microsoft.com]
Use Performance Analyzer to examine report element performance [docs.microsoft.com]

Caching: `Binary.Buffer`, `List.Buffer`, `Table.Buffer`

Power Query, Performance, Microsoft Employee, Mashup, Engine, Quality
https://bengribaudo.com/blog/2019/12/20/4805/power-query-m-primer-part13-tables-table-think-ii

Power Query M Primer (Part 13): Tables—Table Think II

Discusses performance related to using Keys, *.buffer, Formula.Firewall, and links to Power Query team posts about performance

– how-do-i-cache-or-buffer-an-intermediate-query-result-for-repeated-use
– tablebuffer-for-cashing-intermediate-query-results-or-how-workaround-unnecessary-queries-issue
– queries-evaluation-chain

Direct Query

About using DirectQuery in Power BI Desktop [docs.microsoft.com]

Incremental Refresh

Incremental refresh for files in a Folder or SharePoint – Power BI

https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only

Data Refresh in Power BI [docs.microsoft.com]

Tracing and Diagnostics

Power Query Security: Evidence Left Behind

bengribaudo.com covers locations of caches, logs, tracing, and query diagnostics

Connectors

list of all Power platform connectors docs.microsoft.com/en-us/connectors/connector-reference/

list of all Power BI data sources docs.microsoft

Specific connectors: SQL Connector

Query Folding

Query folding guidance in Power BI Desktop docs.microsoft.com

Referenced Queries

Referencing Power Query queries [docs.microsoft.com] Explains why referenced queries run the base query multiple times

Dataflows

Best practices for dataflows [docs.microsoft.com]

`Formula.Firewall` errors

Videos

Add by examples works better than it should.
It dynamically displays the PowerQuery used while you’re entering examples

Alex Powers: Calculated Columns

Time Zones

Handling Different Time Zones in Power BI / Power Query

Web.Contents

Using The “Skip Test Connection” Option For Power BI Data Sources To Avoid Scheduled Refresh Failures

Web.Contents(), M Functions And Dataset Refresh Errors In Power BI

Privacy and Credentials

Power Query Security: Evidence Left Behind

The CredentialQuery Option For Web.Contents() In Power BI Custom Data Connectors

Binary data

Parsing Binary data using Power Query formulas

Read headers of.png images

Using Python

Learning resources