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
Improving Report Performance
Convert Multiple visuals to a matrix and background image
alluringbi.com/2019/10/21/background-concepts-for-power-bi/
alluringbi.com/2020/08/06/consolidating-report-elements-for-improved-performance/
https://dax.tips/2019/08/05/dax-fusion/
https://data-mozart.com/vertipaq-brain-muscles-behind-power-bi/
https://data-mozart.com/tiq-part-1-how-to-destroy-your-power-bi-model-with-auto-date-time/
https://data-mozart.com/inside-vertipaq-compress-for-success/
https://data-mozart.com/how-i-speed-up-my-power-bi-report-5x/
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
Testdocs Value.NativeQuery()
Power Query Tutorials | Docs.microsoft
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
https://www.poweredsolutions.co/2020/01/19/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
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
https://blog.crossjoin.co.uk/2019/04/25/skip-test-connection-power-bi-refresh-failures/
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
More
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns