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
Ask the Community🤝
Want to connect with peers and hear how they work with Kallidus? Our customer Community is a great place to get quick, relatable advice - so jump in, ask your question, and learn from the wider customer Community.
Get deeper learning in The Academy🎓
The Academy provides structured learning paths you can follow at your own pace, along with live events where you can connect with the Kallidus team and fellow learners. Here's some relevant content to get you started:
Looking for quick answers? Explore the FAQ, Reporting and Analytics with Power BI with 100+ common questions and resources.
New to Power BI? Start with the Five must-know features Academy course, then Reporting and analytics 101
You can also join our Ask Me Anything: Reporting live events to ask experts directly.
No Academy account yet? Contact your Customer Experience Manager or Support Team to sign up.