How to View Tables in Power BI

Seeing your raw data is one of the first things you need to do in Power BI, but it’s not always obvious where to look. Unlike a spreadsheet where all your data is right in front of you, Power BI separates your project into different views for different tasks. This guide will show you exactly how to find and view your tables in Power BI for any situation - whether you need to inspect the raw data, understand relationships, or build a table visual for your report.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The Three Views of Power BI Desktop

Before diving into your tables, it's helpful to understand the three main work environments within Power BI Desktop. You can switch between them using the small icons on the far-left side of your screen. Getting a feel for these is the first step to navigating the tool like a pro.

• Report View: This is the canvas where you build your visualizations. It's where you'll drag and drop charts, tables, cards, and slicers to create your interactive dashboard. You’ll spend most of your creative time here.
• Data View: This view lets you inspect the raw data inside your tables row by row. Think of it as Power BI’s built-in version of Excel or Google Sheets, designed for viewing and light data cleaning, not deep analysis.
• Model View: This is a blueprint of your data model. It doesn't show the data itself, but rather the tables you've imported and, crucially, how they are connected to each other through relationships.

Understanding which view to use for your specific goal will save you a ton of time and frustration. Let’s explore how each one helps you view your tables in a different way.

How to View Raw Data in the Data View

The most direct way to see the contents of a single table is through the Data View. If you suspect data quality issues, want to confirm a specific entry, or just need to see your data in a familiar spreadsheet-style format, this is your go-to spot.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is the Data View For?

Use the Data View to look at the individual rows that make up your dataset. It's perfect for tasks like:

• Validating Your Data Load: Quickly check if your data was imported correctly and if all the expected columns and rows are present.
• Spotting Errors and NULLs: Scroll through columns to find blank values (NULLs) or obvious typos that need cleaning.
• Understanding Data Types: See what data type Power BI assigned to each column (e.g., text, whole number, date).
• Sorting and Filtering: Use the column headers to sort your data or apply filters to find specific records without impacting your actual report.

Step-by-Step Guide to Using the Data View

1. Navigate to the Data View: In your open Power BI Desktop file, look to the icons on the far left. Click the middle icon, which looks like a grid or a spreadsheet. This will open the Data View.
2. Select Your Table: On the right-hand side, you’ll see the Fields pane, which lists all the tables in your data model. Simply click on the name of the table you want to see. The data for that table will immediately load in the main window.
3. Inspect Your Data: You can now scroll vertically and horizontally to browse your data. The experience is similar to navigating an Excel sheet. At the bottom-left of the screen, Power BI displays the total number of rows in your selected table, letting you quickly grasp its size.

For example, if you've loaded sales data from a Shopify export, you can click on your orders table in the Data View. From there, you could sort by the order_date column to see the most recent transactions or filter the country column to see only sales from the United States to check for formatting inconsistencies.

How to See Table Relationships in the Model View

Viewing a single table’s data is useful, but the real power of analytics comes from understanding how different tables work together. The Model View doesn’t show you rows of data, instead, it provides a high-level, visual map of your entire data structure.

Why Is the Model View So Important?

Your visuals won't work correctly unless Power BI understands how your tables are related. The Model View is where you define these critical connections. For example, it explains how a 'Sales' table full of transactions connects to a separate 'Customers' table and a 'Products' table.

Without proper relationships, your charts will show incorrect or nonsensical data. For instance, if you try to build a visual showing sales by product category, Power BI needs a relationship between your sales and product tables to know how to calculate it.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Steps to See Your Table Relationships

1. Navigate to the Model View: Click the bottom icon on the far-left navigation pane. This icon looks like three connected boxes, representing tables and their relationships.
2. Examine the Layout: In the main window, each of your tables will appear as a box listing all its columns. Lines will be drawn between these boxes, indicating the relationships that link them. You can click and drag these boxes around to create a clean, logical layout that's easy to read.
3. Inspect a Relationship: Hover your cursor over one of the lines connecting two tables. The fields creating that relationship will be highlighted. For instance, hovering over the line between a Sales table and a Customers table might highlight CustomerID in both, showing they are linked by that common field. Double-clicking the line opens a window with more details about the relationship's configuration.

This view might seem abstract at first, but it is fundamental to building an accurate and reliable report. It answers the "why" behind your visualizations - why filtering by a customer's name in one chart correctly updates the sales data in another.

How to Create a Table Visualization in the Report View

While the Data View is for your eyes only, the Report View is for creating tables that your audience will see. When someone asks to "see the data," this is often what they mean - a clean, organized summary presented as part of a dashboard.

Table visuals are excellent for showing detailed information or providing underlying data that supports a chart on the same page.

Steps for Building a Table Visual

1. Navigate to the Report View: Click the top icon on the left (the bar chart icon) to go to your report canvas.
2. Select the Table Visual: In the Visualizations pane on the right-hand side, find and click the icon for a 'Table'. An empty table template will appear on your report canvas.
3. Add Data to Your Table: With the new table visual selected, go to your Fields pane. Find the columns you want to display and drag them into the Columns field well within the Visualizations pane. Alternatively, you can just check the box next to a field name to add it.
4. Format and Customize: Power BI automatically creates the table, but you’ll want to format it for clarity. With the table visual selected, click the paintbrush icon ('Format your visual') in the Visualizations pane. Here you can adjust everything from text size and column header colors to grid styles and adding totals.

Pro Tip: Add Conditional Formatting for Quick Insights

To make your table visual even more impactful, apply conditional formatting. For instance, you could highlight cells with high revenue in green or low profit margins in red. Navigate to the ‘Format your visual’ options, open the ‘Cell elements’ section, select the column you want to format, and turn on the toggle for ‘Background color.’ This simple step turns a wall of numbers into an easily scannable insight machine.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Tables vs. Matrixes: Choosing the Right Visual

As you build your report, you'll see a 'Matrix' visual right next to the 'Table' visual. They look similar but serve very different purposes. Knowing the difference will help you present your data more effectively.

• Table: A table is a simple two-dimensional grid with rows and columns. It's great for showing detailed information line-by-line, such as a log of individual sales transactions. You add fields to the 'Columns' well, and that’s it.
• Matrix: A matrix is Power BI's version of a pivot table. It allows you to group and aggregate data on both rows and columns. This is perfect for summarizing data across multiple categories. For example, you could show product categories as rows, years as columns, and total sales as the values where they intersect.

In short: use a table for listing detailed records and a matrix for creating summarized cross-tabulated reports.

Final Thoughts

Navigating Power BI gets a lot easier once you understand its core views. The Data View gives you a raw, under-the-hood look at your tables, the Model View shows you how they’re all connected, and the Report View lets you build polished table visuals for sharing insights with others. Using each for its intended purpose is the foundation of building clear and accurate reports.

While mastering Power BI is a valuable skill, the reality is that sometimes you just want clear answers without managing relationships, choosing visualizations, or dragging-and-dropping fields. We built Graphed to remove this friction entirely. Instead of configuring views and settings, you just connect your data platforms and ask questions in plain English - like "show me a table of monthly sales by campaign" or "what are my top 10 products by revenue this quarter?" Graphed automatically builds the interactive tables and dashboards you need, turning hours of manual work into a 30-second task.