A list of useful PBI related blog posts and docs
DAX
Dynamic M Query Parameters (preview)
Unlock the Power of Dynamic Parameter Binding for DirectQuery
a Tutorial by Artemus
Dynamic M query parameters (preview) [docs]
Power BI 2020 Feature Summary: Dynamic Parameters in DirectQuery
Saving Power Query source code in one copy
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
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
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
Data Refresh in Power BI [docs.microsoft.com]
Tracing and Diagnostics
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
- Docs: Behind the scenes of the Data Privacy Firewall
- Data Privacy and the Formula Firewall in Power BI / Power Query
- Data Privacy Settings In Power BI/Power Query, Part 3: The Formula.Firewall Error
- Docs: Power BI Desktop privacy levels
Videos
It dynamically displays the PowerQuery used while you’re entering examples
Time Zones
Web.Contents
Privacy and Credentials
Binary data
.png
imagesUsing Python
- Using Python as a Data Source
- Custom Report Visuals written in Python
- Modules available on the Power BI Service when using Custom Visuals written in Python