From Power BI to Excel - The best of two worlds
summary
Shows how to open a Power BI cloud dataset in Excel by installing the Analyzing in Excel add‑in, download an .xls pivot connected live to the Azure model, and refresh values (demonstration republished a changed measure and Excel updates). Teaches converting pivots to formulas and using CUBEVALUE/CUBESET with MDX-like member expressions, named ranges and automated DAX queries to export or join multiple datasets, and warns tenant controls, hidden fields and need for explicit measures.
AI-written summary · about
chapters (13)
- 0:00Introduction and objectives
- 4:52History and importance of Excel
- 12:00Connecting Power BI to Excel
- 15:29Demo: Analyzing data in Excel
- 21:57Demo: Multiple data sets in Excel
- 24:02Key considerations for analysis
- 26:30Demo: Clean model requirements
- 28:14Demo: Advanced pivot table techniques
- 33:57Cube functions and cube sets
- 37:09Feeding existing reports with Power BI
- 39:14Named ranges for intuitive analysis
- 43:10Architecture and takeaways
- 44:37Q&A and closing remarks
related talks
43mFrom Power BI to Excel - The best of two worlds
18mEmpowering Business Through Data
20mConnect Excel to Power BI data with Live Connected Tables
01h 01mDiscover, Manage, Analyze, and Visualize Your Data with Power BI
58mPower BI for the Developer
48mCombine Power BI with External Tools
01h 08mAdvanced Modelling and Calculation Using the Power BI Designer
50mBuilding an Empire - Implementing Power BI Step by Step