Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
You can export app data to an Office Excel PivotTable to see patterns and trends in data. An Excel PivotTable is a great way to summarize, analyze, explore, and present your app data. You can export up to 100,000 rows at a time.
A few things to note:
On the left nav, select a table.
On the command bar select the Export to Excel menu, and then select Dynamic PivotTable.
In the Select Columns for Pivot Excel dialog box, select the column settings and then select Export.
By default, the PivotTable Column List includes only columns that are displayed in the Select Columns for Pivot Excel list.
When the download is complete, navigate to the location of the downloaded file.
Note
When you download a worksheet it should automatically save to your computer. However, if it doesn't then make sure that you save it before you open and edit it. Otherwise, you might get this error message: Excel cannot open or save any more documents because there is not enough available memory or disk space.
To fix the issue:
We still strongly recommend that you save and then open the data file rather than disabling protected view, which might put your computer at risk.
Open the saved Excel file.
If you see the security warning External Data Connections have been disabled, select Enable Content.
Note
If don't see any data and you get an error, see Refresh all doesn't work.
To add a PivotTable, on the Insert tab, select PivotTable.
Note
You must complete this step to insert the PivotTable. The PivotTable is not created automatically.
Drag the columns from the PivotTable Column List to the PivotTable. For more information, see Overview of PivotTables and PivotCharts.
Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreTraining
Module
Export data from Dataverse and use Microsoft Excel to edit records - Training
Discover how to export and edit Microsoft Dataverse table data using Excel files, while understanding security concepts.
Certification
Microsoft Office Specialist: Excel Expert (Office 2016) - Certifications
Demonstrate that you have the advanced skills needed to get the most out of Excel 2016 by earning a Microsoft Office Specialist (MOS) Expert certification.