Others

Fix DAX Resource Exceeded Error When Concatenating Tables in Power BI

Elise WilliamsElise Williams Oct 10, 2026 870 views

Question details

The user needs to concatenate fields from multiple related tables to identify duplicates but encounters DAX resource limitations.

Fixing DAX Resource Exceeded Errors When Concatenating Fields in Power BI
Product
Power BI
Device & OS
not provided
Scenario
Attempting to concatenate fields across multiple tables containing millions of records to find and manage duplicate entries.
Observed behavior
Power BI throws a resource-exceeded error during the DAX calculation and appears to restrict the visual fields to a single table.
Before you start

Before modifying your DAX calculations, check your system's available RAM and close unnecessary background applications, as processing millions of concatenated rows dynamically is heavily memory-intensive.

Solution 1Recommended

Perform Concatenation in Power Query Instead of DAX

Moving row-level text operations to Power Query reduces the calculation burden on the DAX engine during report rendering.

DAX is highly optimized for aggregations but struggles with row-by-row string manipulation on millions of records. Pushing this transformation upstream to Power Query ensures the concatenation happens during data load, not at runtime.

1
Open Power Query Editor

In your Power BI Desktop report, click on 'Transform Data' in the Home ribbon to launch the Power Query Editor.

2
Merge the Related Tables

Select your primary table, click 'Merge Queries' in the Home tab, and select the related table along with the matching key columns to join them.

3
Add a Custom Column

Navigate to the 'Add Column' tab, click 'Custom Column', and write an M formula such as [Column1] & "-" & [Column2] to concatenate the required fields.

4
Apply and Load

Click 'Close & Apply' on the Home tab to load the optimized, pre-concatenated dataset back into your Power BI data model.

Perform Concatenation in Power Query Instead of DAX
Performance Boost: Pre-calculating these text values in Power Query eliminates the DAX overhead, preventing resource-exceeded errors when loading your table visuals.
Free Microsoft Office alternative

Handle Your Daily Data Tasks with WPS Office

While Power BI is necessary for millions of rows, everyday data cleaning, concatenation, and deduplication for smaller datasets can be easily handled in WPS Spreadsheet. WPS Office offers a lightweight, free alternative to Microsoft Office with full compatibility for your Excel files.

  1. 1. Download and Install: Visit the official WPS website to download and install WPS Office for free.
  2. 2. Open WPS Spreadsheet: Launch WPS Spreadsheet and open your exported data file (.csv or .xlsx).
  3. 3. Process Your Data: Use the CONCATENATE function or the 'Data' > 'Remove Duplicates' tool to efficiently manage your records.
Fully compatible with Microsoft Excel (.xlsx, .csv) formats.Includes built-in functions like CONCATENATE and Remove Duplicates for quick data cleanup.Lightweight installation with a familiar, tabbed user interface.Free to download and use across Windows, Mac, Linux, and mobile devices.
microsoft office alternative - wps office

Frequently Asked Questions

Why do I get a resource-exceeded error in Power BI?

This error occurs when a DAX query requires more memory than your system or the Power BI service can allocate. It frequently happens during complex row-level calculations or string manipulations on millions of rows.

Can I concatenate columns from different tables using DAX?

Yes, but you must use functions like RELATED() if the tables share a valid relationship. However, performing this calculation on millions of rows dynamically inside a visual often leads to severe performance degradation.

What is the most efficient way to find duplicates across multiple columns?

The most efficient method is to concatenate the columns in Power Query to create a unique composite key. Once the key is created, you can use the 'Group By' or 'Keep Duplicates' features in Power Query to isolate repeating values before the data even loads into DAX.