How to build a Direct Query Power BI Report that is NOT slow
Learn how to optimize your Power BI DirectQuery reports for lightning-fast performance! This tutorial dives into performance analysis, custom SQL queries, and M query parameters, with a comparison of different techniques.
Video Chapters
00:00 - Introduction
01:11 - Direct Query Report #1 - Classic
01:51 - Preformance Analyzer
02:28 - Power BI SQL
04:28 - Direct Query Report #2 - Custom
04:41 - M Query Parameters
07:06 - Comparing performance
Come learn SQL with me: • Learn SQL for Free
⸺⸺⸺
🚀 WORK WITH ME
Email: [email protected]
📱 FOLLOW ME ELSEWHERE
LinkedIn: / edward-charles-085025b1
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
📚 BOOKS I USED TO LEARN BI
[SQL]
SQL in 10 Minutes a Day: https://amzn.to/3VZztG2
T-SQL Fundamentals: https://amzn.to/3Pe5XbC
T-SQL Querying: https://amzn.to/3Pe5XbC
[POWER BI]
Learn Power BI: https://amzn.to/49YiM3C
Definitive Guide to DAX: https://amzn.to/408zI3K
💻 VIDEO & DESK GEAR
Keyboard (Keychron K10 Max - available on their site): https://www.keychron.com/?ref=EDWARDC...
Mouse (MX Master 4): https://amzn.to/4tuIgPg
Affiliate Disclosure: Some of the links in this description are affiliate links. I may earn a commission if you purchase through them at no extra cost to you.
⸺⸺⸺