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
Follow me on LinkedIn: / edward-charles-085025b1
📚 Books I used to Learn Business Intelligence 📚
💻 SQL:
SQL in 10 Minutes a Day, Sams Teach Yourself: https://amzn.to/3VZztG2
T-SQL Fundamentals (Developer Reference): https://amzn.to/3Pe5XbC
T-SQL Querying (Developer Reference): https://amzn.to/3Pe5XbC
📊 Power BI:
Learn Power BI: https://amzn.to/49YiM3C
Definitive Guide to DAX: https://amzn.to/408zI3K
