Home › Microsoft Power BI › DAX_QUERY_TIMEOUT

Microsoft Power BI · DAX_QUERY_TIMEOUT · Windows 11 23H2

Power BI DAX_QUERY_TIMEOUT Windows 11 23H2 Report Visuals Timeout

Unoptimized DAX measures or missing relationships cause timeouts; rewrite SUMX as CALCULATE+SUM and add summarization.

Error Details

FactValueSourceNote
Exact error stringDAX_QUERY_TIMEOUTPower BI Desktop log file-> analysis services
Affected build rangeWindows 11 23H2Microsoft Docs
Registry key involvedHKLM\SOFTWARE\Wow6432Node\Microsoft\Power BI Desktop\v.2.*\Settings\TimeoutInMinutesRegistry Editor-> default 15
Relevant service/endpoint URLhttps://api.powerbi.com/v1.0/myorg/datasetsPower BI REST API documentation
Log line signatureDAX query timeout after 225 secondsPower BI Desktop log file-> DAX Studio trace

Log Files to Check

What This Error Actually Means

The error code DAX_QUERY_TIMEOUT is raised by Power BI Desktop when a DAX query sent to an Analysis Services engine or import-mode dataset exceeds the default timeout period of 225 seconds. The DAX language, used for data modeling in Power BI, allows complex calculations and aggregations that can be resource-intensive. When such queries take longer than expected due to inefficiencies or large datasets, Power BI Desktop fails to retrieve results within the allowed time frame and throws this error.

Affected Versions and Scope

This issue affects users running Power BI Desktop on Windows 11 build 23H2. It is particularly relevant for organizations using import-mode datasets in Power BI reports where DAX queries are executed against large data volumes or complex calculations. The problem does not affect DirectQuery mode, which retrieves data directly from the source without importing it into a dataset.

Where To Look First: Logs and Event IDs

To diagnose this issue, start by examining the Power BI Desktop log files located at C:\Users\\AppData\Roaming\Microsoft\Power BI Desktop\Logs\PBIDesktop_YYYYMMDD_HHMMSS.log. Search for the exact error message: "DAX query timeout after 225 seconds". Additionally, DAX Studio logs can provide deeper insights and are stored at C:\Program Files\DAXStudio\Logs\DAXStudio_YYYYMMDD_HHMMSS.log. Event IDs related to this issue include 1073 (indicating a query timeout) and 256 (reporting DAX execution issues). These can be found in the Windows Event Viewer under "Applications and Services Logs" > "Microsoft" > "Power BI Desktop".

Root Causes

Unoptimized DAX Measures with SUMX Over Large Tables

When a measure uses SUMX over large tables, it can lead to performance issues. This is because SUMX iterates through each row of the table and performs calculations for every single record, which is inefficient on large datasets.

Missing Column Relationships Between Tables Missing or incorrect relationships between tables in a Power BI model can cause cardinality explosions. When there are no proper relationships defined, Power BI may attempt to perform full table scans instead of using indexed joins, leading to performance degradation and timeouts.

Fix Procedure

To address the DAX_QUERY_TIMEOUT issue, follow these steps: 1. **Identify Unoptimized Measures**: Use DAX Studio to analyze your measures for inefficiencies. Focus on any use of SUMX over large tables and consider rewriting them using more efficient patterns such as CALCULATE + SUM. 2. **Optimize DAX Queries with DAX Studio**: Open the problematic report in Power BI Desktop, then open DAX Studio to trace server timings. Look for high StorageEngine duration values which indicate inefficient queries. 3. **Adjust Timeout Settings via Registry Editor**: - Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Power BI Desktop\v.2.*\Settings in the Windows Registry. - Modify or create a new DWORD value named TimeoutInMinutes. Set its value data to an appropriate timeout duration (e.g., 10 minutes) to allow longer-running queries. 4. **Implement DirectQuery Mode**: - For datasets with extremely large tables, consider switching from import mode to DirectQuery. - Use the Power BI admin portal at Power BI admin portal > Gateway management to configure a new DirectQuery connection. 5. **Enable Incremental Refresh**: - Navigate to the Power BI service and select "Settings" for your dataset. - Enable incremental refresh settings to reduce the amount of data processed during each refresh cycle, thereby improving performance.

Error Code Variants

Code Description Distinguishing Features
DAX_QUERY_TIMEOUT Query execution exceeds default timeout period. Specific to DAX queries in import-mode datasets.
DATA_SOURCE_NOT_FOUND Data source not found or inaccessible. Occurs when Power BI cannot connect to the data source, unrelated to query performance.
REFRESH_FAILED Dataset refresh fails due to various reasons including connectivity issues. Indicates a problem with dataset refresh rather than DAX query execution.

Verification

After implementing the fixes, verify that the issue has been resolved by checking the Power BI Desktop logs for any new instances of "DAX query timeout after 225 seconds". Additionally, monitor the dataset refresh history and activity log in the Power BI admin portal to ensure smooth operation without timeouts.

Prevention

To prevent recurrence of DAX_QUERY_TIMEOUT errors, implement a baseline policy that requires all datasets to be optimized for performance before deployment. This includes enforcing best practices such as avoiding SUMX over large tables, ensuring proper relationships between data models, and regularly reviewing query performance using tools like DAX Studio.
Be cautious when adjusting timeout settings via the registry editor, as incorrect changes can affect system stability.
A quick diagnostic shortcut is to run Get-PowerBIActivityEvent -StartDateTime (Get-Date).AddHours(-2) -EndDateTime (Get-Date) | Where-Object Activity -eq "RefreshDataset" in the Power BI PowerShell module to check recent dataset refresh activities.
This guide provides a comprehensive approach to diagnosing and resolving DAX_QUERY_TIMEOUT errors, ensuring that your Power BI reports run smoothly without performance issues.

Sources & References

Related Guides

Get new error code fixes by email

Product-specific solutions for Intune, Autopilot, SCCM and Entra ID — straight to your inbox. No spam.