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
- Click to select a Table Visualisation
-
Select the 3 dots in the top right of the table (hover over the table if the dots are not visible):
- Select Export data
- Choose a data export option:
- Select Export. The data will appear in the downloads folder on your computer
Discover more about reporting with Power BI
Looking for quick answers? Check out FAQ, Reporting and Analytics with Power BI, packed with over 100 common questions and links to in-depth resources.
If you're new to reporting with Power BI, Reporting and analytics 101 introduces the fundamentals to help you get started. For a deeper dive, the short Academy Course Five must-know features explores these key topics in more detail and serves as the starting point for the Get Started: Reporting and analytics with Power BI course.
You can also join our regular Ask Me Anything: Reporting live events - come along and ask your question directly to our panel of experts.
Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.