How to Increase Table Size in Power BI

Hitting a limit on how much data you can show in a Power BI table or matrix is a common frustration. You've loaded your data, you know the information is there, but your visual gets cut off or displays a cryptic message about resource constraints. This article will walk you through several practical methods to increase the size and capacity of your tables, from simple formatting tricks to more strategic report design choices that give your users the detail they need without crashing the report.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

First, Why Does Power BI Have Size Limits?

Before diving into the "how," it's helpful to understand the "why." Power BI imposes limits on visuals for a critical reason: performance. Unlike Excel, which can feel like an endless grid, Power BI is designed for interactive data visualization. Every visual on your report page, including tables and matrices, requires the Power BI engine to query, aggregate, and render data dynamically.

If visuals could show millions or billions of rows at once, reports would become slow, unresponsive, and difficult for users to navigate. The limits are guardrails to ensure a smooth user experience. The key isn't always to brute-force more data onto the screen, but to work with these limits smartly or find better ways to present the information.

• Data Point Limits: Most standard visuals have a cap on the number of individual data points they can render, often around 30,000.
• Matrix Visual Limits: Matrices have higher limits but are still constrained. By default, they can show up to 100 columns and handle around 500,000 data "intersections" (the cells where rows and columns meet) before performance might degrade significantly. Too many unique values in your rows or columns can quickly multiply to hit these capacity constraints.
• Resource and Memory Caps: Both Power BI Desktop and the Power BI Service have finite memory resources. A single massive visual can consume too much memory, slowing down not just that visual but the entire report page.

The goal is to provide users access to detailed data without sacrificing the speed and interactivity that make Power BI powerful in the first place.

Method 1: Quick Formatting and Layout Adjustments

The easiest wins often come from simple adjustments in the formatting pane. If your issue is more about fitting content on the screen rather than hitting a hard data query limit, start here. These small tweaks can dramatically increase the perceived size and density of your table.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Reduce Font Size, Padding, and Spacing

By default, Power BI tables have generous padding and spacing to prioritize readability. You can tighten this up considerably to fit more rows and columns into the same physical space on your report canvas.

1. Select your table or matrix visual.
2. Go to the Format your visual pane (the paintbrush icon).
3. Expand the Grid section. Here you can adjust horizontal and vertical gridlines.
4. Expand the Values section. This is where you can decrease the Font size. Don't be afraid to go down to 9pt or 8pt if it remains readable.
5. Under Values, go into Options and adjust the Padding. Reducing this from the default of 4 down to 1 or 2 can make a huge difference in vertical space.
6. Do the same for your Column headers and Row headers. Decrease the font size and padding to match your values.

Adjust Column Widths and Text Wrapping

Long column headers or text values can take up unnecessary horizontal space. Take control over how your text is displayed.

1. Select your table visual.
2. In the Format your visual pane, expand the Column headers section.
3. Under Options, you'll find a toggle for Text wrap. Turning this off will prevent headers from spilling onto multiple lines, saving vertical space.
4. You can then manually drag the column dividers in the visual itself to make each column as narrow as possible. For quickly fitting everything, go to Specific column in the formatting pane, select a column, and toggle Auto-size width on and off to see how it adjusts.

Method 2: Adjusting Query Limits for Data Display and Export

If formatting doesn't solve it, you may be hitting actual data retrieval settings within Power BI Desktop. These settings govern how much data is pulled from your model to populate visuals.

For Power BI Desktop Analysis

Power BI Desktop allows you to modify the maximum number of records retrieved for queries. It's important to use this with caution, as setting it too high can lead to performance issues in the desktop environment, especially with large datasets.

1. In Power BI Desktop, go to File > Options and settings > Options.
2. Under the CURRENT FILE section, click on Report settings.
3. Look for the option Maximum number of data points all visuals can display. You can increase this from the default, but be mindful of the performance warnings.

Increasing the Row Limit for Data Export

Often, the reason someone wants a giant table is not for analysis on the screen, but to export the data to Excel or a CSV file. Power BI has separate, much higher limits for data export that can be adjusted upward.

1. In Power BI Desktop, navigate to File > Options and settings > Options.
2. In the GLOBAL section, click on Security.
3. Under the Data Export section, you can change the setting from 'Summarized Data' to 'Both summarized and underlying data' to allow more flexible exports.
4. More importantly, in the Power BI Service, a capacity admin can configure export limits. Standard .csv file exports are capped at 30,000 rows. However, for users with a Power BI Pro or Premium Per User (PPU) license, they can export data in the .xlsx format, which has a much higher limit of 150,000 rows.

For exports exceeding these limits, you're venturing into the territory of more advanced tools like Paginated Reports, which we'll cover below.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Method 3: A Smarter Approach - Rethink Your Report Design

This is often the best solution. Instead of trying to force Power BI to act like a spreadsheet, use its interactive features to deliver granular data in a more controlled and useful way.

Use Slicers and Filters to Reduce Scope

A table showing 2 million sales transactions is not an analysis, it's a data dump. Empower your users to get the details they need by filtering them down. Instead of showing everything at once, add slicers to your report for key dimensions like:

• Date Range (e.g., Year, Quarter, Month)
• Region or Country
• Product Category or SKU
• Sales Representative

By forcing a user to select a product category, for instance, the table can be filtered to a much more manageable and relevant size before it even tries to render.

Implement Drillthrough Pages for Focused Detail

Drillthrough is one of Power BI's most powerful features for managing data complexity. The concept is simple: your main report page shows a high-level summary, and users can right-click a specific data point to "drill through" to a separate, hidden page containing the detailed, row-level data for just that selection.

How to Set it Up:

1. Create your main report page with summary visuals (e.g., a chart of sales by region).
2. Create a new, hidden report page. Call it something like "Sales Detail."
3. On this new page, add the huge, detailed table you want to display.
4. In the Visualizations pane for this detail page (with no visuals selected), drag the field you want to filter by into the Drillthrough filters area at the bottom. For our example, you would drag the "Region" field here.
5. Power BI will automatically add a "Back" button to your detail page.
6. Now, go back to your main summary page. Right-click on a region in your chart (e.g., the bar for "North America") and you'll see a Drillthrough option pointing you to your "Sales Detail" page. When you click it, you are taken to the detail page, and the table is automatically filtered to show only data for North America.

Leverage Report Tooltips

Similar to drillthrough, you can provide a peek at detailed data without cluttering your main view using report tooltips. You can design a small report page to act as a custom tooltip. When a user hovers over a data point on a primary visual, this tooltip page appears, showing a small table, KPI cards, or other relevant details.

This allows you to show, for example, the top 5 transactions for a specific day when a user hovers over that day on a line chart. It delivers context on demand.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Advanced Solution: Use Paginated Reports for Massive Exports

For times when you genuinely need a pixel-perfect, potentially thousand-page table ready for printing or exporting, the right tool for the job is a Paginated Report. This feature is available with Power BI Premium or PPU licenses.

Unlike standard interactive Power BI reports (.PBIX), Paginated Reports (.RDL) are built for large-scale, formatted reporting. They are the spiritual successor to SQL Server Reporting Services (SSRS).

• No Row Limit: They are designed to handle effectively unlimited rows and stream all the data from your source.
• Pixel-Perfect Layout: You have precise control over headers, footers, pagination, and printing formats.
• Multiple Export Formats: Export to PDF, Word, Excel, CSV, and more with high fidelity.

Creating one involves using a separate free application called Power BI Report Builder. You connect it to your published Power BI dataset, design your table layout, and then publish the report to the Power BI Service. While it's a more formal development process, it's the definitive answer for any "give me all the data" requests.

Final Thoughts

Addressing table size limits in Power BI is a matter of choosing the right approach for your goal. Whether it involves quick formatting tweaks, changing back-end settings, employing smart design patterns like drillthrough, or using the right tool like Paginated Reports, you can provide your users with the detailed data they need in a high-performing and useful format.

The time spent clicking through formatting panes and setting up drillthrough pages is often a symptom of traditional BI complexity. Instead of wrestling dashboard builders to answer your next question, imagine just asking for the information you need in plain English. We built Graphed to remove this friction by connecting your data sources and allowing you to instantly create dashboards and get insights simply by describing what you need, turning hours of report building into a 30-second conversation.