Connect Excel to Power BI data with Live Connected Tables

on YouTube ↗20m

" summary

Demonstrates how to export Power BI data into Excel as Live Connected Tables that stay linked to the Power BI semantic model, rerun the original DAX query on refresh, and handle up to 500,000 rows (export limits apply). Shows creating tables via export, the Power Platform connector, and exporting an ODC connection so others can open the same live table; reveals the DAX is embedded (editable by copying into DAX Studio), notes faster DAX vs MDX pivots and current limits on query editing and formatting.

AI-written summary · about

" chapters (8)

1. 0:00Live connected tables intro
2. 1:56Exporting with live connection
3. 6:17Alternative live table methods
4. 9:12Editing DAX queries
5. 12:27Refreshing and sharing connections
6. 14:35Advantages over pivot tables
7. 18:30Performance benefits and future
8. 19:56Q&A

" related talks

• 47mFrom Power BI to Excel - The best of two worldsPedro Reis · Global Azure 2021
• 43mFrom Power BI to Excel - The best of two worldsPedro Reis · Global Azure Virtual 2021
• 18mEmpowering Business Through DataDeepthi Anantharam · Great Indian Developer Summit 2015
• 51mPower BI Composite and Hybrid ModelsAlex Whittles · SQLBits 2023
• 01h 01mDiscover, Manage, Analyze, and Visualize Your Data with Power BIMiguel Martínez · PASS Business Analytics Conference 2015
• 58mBig Data Analytics with Excel 2013Peter Myers · PASS Business Analytics Conference 2013
• 58mProductivity Revolution in ExcelAvi Singh, Purna Duggirala · PASS BA Marathon 2015
• 58mPower BI for the DeveloperPeter Myers, Chris Webb · NDC London 2023