Fix DAX Resource Exceeded Error When Concatenating Tables in Power BI
Question details
The user needs to concatenate fields from multiple related tables to identify duplicates but encounters DAX resource limitations.

- 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 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.
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.
In your Power BI Desktop report, click on 'Transform Data' in the Home ribbon to launch the Power Query Editor.
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.
Navigate to the 'Add Column' tab, click 'Custom Column', and write an M formula such as [Column1] & "-" & [Column2] to concatenate the required fields.
Click 'Close & Apply' on the Home tab to load the optimized, pre-concatenated dataset back into your Power BI data model.

Optimize the Data Model and Pre-filter Data
Reducing the total data volume and optimizing relationships prevents the engine from exceeding available memory resources.
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. Download and Install: Visit the official WPS website to download and install WPS Office for free.
- 2. Open WPS Spreadsheet: Launch WPS Spreadsheet and open your exported data file (.csv or .xlsx).
- 3. Process Your Data: Use the CONCATENATE function or the 'Data' > 'Remove Duplicates' tool to efficiently manage your records.

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.




