Reporting - Add a table visualisation to a report

*** Please note, this article refers to Reporting and Analytics with Power BI. View the FAQ for more details. ***

In this article, we’ll show how to add a table visualisation to a page in Power BI.

Table visualisations are probably the most common data visualisation used in Power BI. They're a quick and easy way to summarise key points of information. With a table visualisation, you can:

• Decide which data fields you want to include
• Easily add more columns or remove ones you no longer need
• Choose the sequence in which your columns appear
• Re-name some of your columns to suit your report audience

Note that Power BI has a 150,000-row data export limit, so take care when creating a table if you are thinking of exporting your data. Look at how filters can be applied to reduce the volumes.

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

Steps to add a table visualisation to a report

1. Start a new User-created report
2. From the Visualisations panel, select 'Table visualisation'. An empty table will be added to the report:
3. Check that the table visualisation is still the selected item on the page. To populate the table, select or drag fields from the Data panel. In this example,a combination of fields and measures are used:
4. Save the report when you're done

If a table is not quite right, try a matrix visualisation. It’s similar to a table visualisation but with some handy interactive features.

Discover more about User-created reports

For a hands-on learning experience, explore our Deep dive courses in The Academy, and watch as Gary builds reports from scratch to meet specific briefs. 

If you prefer to start at the beginning, check out Get Started: Reporting and Analytics with Power BI. You'll begin with Power BI’s top five features, then dive deeper into each one with step-by-step guidance.

Need quick answers? Check out our FAQ, Reporting and Analytics with Power BI, packed with 100+ common questions and in-depth resources. You can also join our regular Ask Me Anything: Reporting live events, to ask your question directly to a Power BI expert. Search PWRFAQ in The Academy for real-world use cases, examples, and scenarios with User-created reports.

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