Reporting - Export a table Visualisation to Excel

*** Please note, this article refers to the All-new Reporting and Analytics. View the FAQ for more details. ***

In this article, we’ll show how to export a Table Visualisation to Excel from a Power BI report. When it's time to export data, there are two options - 'data with current layout', and 'summarised data'. 

Data with current layout

With this option, you'll get a simple unformatted table with the same layout as in Power BI. All formatting present in Power BI is removed. The export will look like this:

Summarised data

A summarised export will retain any filters applied to the Table Visualisation. Rows will be colour-coded, and pre-built filters will be applied to columns. It will include the summarized data used to create your visual (for example, sums, averages, and medians). The export will look like this:

Note that a maximum of 150,000 rows can be exported at a time so before exporting data, we recommend filtering the report to show just the information you need. This will also make the export much easier to work with.

Watch the video and follow the steps below to see how:

Steps to export a table visualisation to Excel

1. Click to select a Table Visualisation
2. Select the 3 dots in the top right of the table:
3. Select 'Export data'
4. Choose a data export option:
5. Select Export. The data will appear in the downloads folder on your computer

Find out more about reporting and analytics with Microsoft Power BI

Join us live for Key techniques for using Power BI fixed reports in The Academy. We'll start with a tour of the Power BI reporting area, then, we’ll open up the Learning Progress report and using real-life examples, we’ll dive into the detail.

If you're using Reporting and Analytics already and have a question, come along to our 'Ask me Anything' events in the Academy to ask questions and share feedback directly with the team.

Join us for our update and roadmap live event to see the latest feature releases and roadmap for the next quarter and share feedback directly with the team. 

Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.