Download Excel File: https://excelisfun.net/files/EMT1729.xlsx and https://excelisfun.net/files/EMT1729Finished.xlsx
Learn about the new Microsoft 365 Create PivotTable dialog box with your data source options: Excel Table, External, Data Model and Power BI. This dialog box is much different than in the past. They have moved the data source connection out of the dialog box and into the Ribbon.
The four new dialog boxes are:
PivotTable from table or range.
PivotTable from external source
PivotTable from Data Model
Power BI Data Set Task Pane
Topics:
1. (00:00) Introduction
2. (00:23) #1 Create PivotTable dialog box for Excel Tables.
3. (01:15) #2 Create PivotTable dialog box for External Data (Power Query Connection Only).
4. (02:06) Bonus trick #1: Change Query load location from connection only to PivotTable.
5. (02:35) #3 Create PivotTable dialog box for Data Model.
6. (03:32) Bonus Trick #2: Publish Excel Power Pivot Data Model to Power BI Online to give a team universal access.
7. (05:24) #4 Create PivotTable dialog box for Power BI Online Data Model (universally stored in one location for a group of analysts).
8. (06:26) Where is Power BI Online Connection in Excel workbook?
9. (06:40) Summary, Closing and Video Links