From Power BI to Excel - The best of two worlds
summary
Shows how to use the Analyze in Excel MSI plugin to open Power BI cloud datasets in Excel, connect multiple Power BI datasets in one workbook, and refresh live values back to the service (demo publishes and refreshes successfully). Demonstrates converting pivot tables to MDX formulas and using CUBEVALUE/CUBEMEMBER/CUBESET plus named ranges for dynamic queries to build granular reports, create custom groups, and feed existing Excel reports; requires at least one explicit measure and hides implicit or hidden fields.
AI-written summary · about
chapters (9)
- 0:00Introduction and session overview
- 11:00Connecting Power BI to Excel
- 14:09First demo: Analyzing Power BI data in Excel
- 21:05Key considerations for Excel analysis
- 24:49Advanced pivot table techniques
- 31:15MDX and cube functions in Excel
- 35:48Feeding existing Excel reports
- 37:54Named ranges for simplified access
- 41:24Architecture and takeaways
related talks
47mFrom Power BI to Excel - The best of two worlds
18mEmpowering Business Through Data
20mConnect Excel to Power BI data with Live Connected Tables
01h 05mDynamic Presentation Using Excel CUBE Formulas
01h 01mDiscover, Manage, Analyze, and Visualize Your Data with Power BI
50mBuilding an Empire - Implementing Power BI Step by Step
01h 08mAdvanced Modelling and Calculation Using the Power BI Designer
58mReal world PowerBI