This Power BI to Excel Trick Will Blow Your Mind (But Don't Actually Use It)
In this video, we dive into Excel Power Pivot and explore how to use XMLA endpoints to execute DAX queries against Power BI semantic models, bringing your data into Excel.
Video Chapters:
00:00 - Introduction
01:12 - Logging into the XMLA Endpoint
02:02 - A Quick Look at Excel
02:30 - Introducing Power Pivot
03:32 - Querying the Power BI Model with Excel
Want to learn more?
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
