Reference
Power BI Refresh Error Codes
34 error codes with root causes, step-by-step fixes, and related resources. Find your error in the list below or use your browser search (Ctrl+F / ⌘F).
Gateway errors9Credential errors4Data source errors9Query errors6Privacy & firewall2Capacity errors2Schema errors2
Gateway errors
High→
DM_GWPipeline_Gateway_MashupDataAccessError
The on-premises data gateway failed to access the data source during the Mashup (Power Query) evaluation phase. This is …
High→
DM_GWPipeline_Gateway_SpooledJobTimeout
The refresh job waited too long in the gateway's queue before execution began. The gateway was overloaded, and the job e…
Critical→
DM_GWPipeline_Gateway_ServiceBusConnectionFailed
The on-premises data gateway cannot connect to Azure Service Bus, which is the communication channel between Power BI Se…
Critical→
DM_GWPipeline_Gateway_NetworkUnreachable
The gateway machine cannot reach the target data source over the network. The host is either down, has moved, or is bloc…
Medium→
DM_GWPipeline_Gateway_CertificateNotTrusted
The gateway rejected the SSL/TLS certificate presented by the data source because it is self-signed, expired, or issued …
High→
OLE DB or ODBC error
The ODBC or OLE DB driver used to connect to the data source returned an error. This is common with on-premises database…
High→
A gateway is required but none is configured
The dataset uses a data source that requires an on-premises data gateway, but no gateway is associated with this dataset…
High→
DM_GWPipeline_Gateway_UnknownError
An unclassified error occurred within the on-premises data gateway pipeline. This error code is a catch-all when the gat…
Critical→
Gateway cluster not found
The gateway cluster that was previously associated with this dataset no longer exists or is no longer accessible. This d…
Credential errors
High→
Credentials are invalid
The credentials used to access the data source are rejected. This can happen after a password change, token expiration, …
High→
Insufficient permissions to access this resource
The account used to refresh the dataset does not have the required permissions on the data source. The connection succee…
Critical→
Refresh schedule disabled due to consecutive failures
Power BI automatically disables the refresh schedule when a dataset fails multiple consecutive times. Once disabled, the…
High→
Unable to connect (credentials are required)
Power BI Service cannot find stored credentials for this data source. The data source connection in the cloud is not bou…
Data source errors
High→
DM_ErrorCode_Connection_TestFailed
Power BI could not establish a connection to the data source when testing connectivity. This error typically appears whe…
High→
DataSource.Error
Power Query could not connect to or read from the data source. This is a wrapper error that usually contains a more spec…
High→
DM_GWPipeline_Gateway_DatabaseError
The database returned an error to the gateway during the refresh query. Unlike connection errors, this means the gateway…
High→
DM_ErrorCode_BackEnd_QueryExecutionFailed
The Analysis Services engine (the backend that processes your data model) failed while executing a query against the dat…
High→
AdomdConnectionException
The Analysis Services client library (ADOMD.NET) failed to connect to the Analysis Services or Azure Analysis Services i…
Medium→
OData: The response is not a valid OData feed or service document
The OData connector received a response from the endpoint that is not valid OData XML or JSON. This usually means the AP…
High→
DM_ErrorCode_BackEnd_QueryExecutionFailed_DirectQuery
A DirectQuery dataset generated a query to the data source that failed to execute. Unlike Import mode, DirectQuery sends…
Medium→
DM_ErrorDetailNameCode_ExecutionContext
An error occurred within a specific execution context of the Power BI data processing pipeline. This error is often seen…
Medium→
Connection string not supported
The connection string used in the dataset contains options or syntax that Power BI Service or the gateway does not suppo…
Query errors
Medium→
Expression.Error
A Power Query (M language) expression failed to evaluate during refresh. This error surfaces when query logic produces a…
High→
DM_GWPipeline_Gateway_NativeQueryError
The native SQL query (passed directly to the data source) returned an error. This error surfaces when a dataset uses nat…
High→
Query timeout expired
The data source query ran longer than the allowed timeout period and was cancelled. Power BI enforces query timeouts to …
Medium→
The key didn't match any rows in the table
A lookup or merge operation in Power Query tried to find a key value that does not exist in the lookup table. This happe…
Medium→
Microsoft.Data.Mashup.MashupValueException
The Power Query (Mashup) engine encountered a value that violates a constraint or is structurally incompatible with the …
Low→
DM_GWPipeline_Gateway_QueryCancelledByUser
The refresh query was cancelled before it completed. This can be triggered manually or automatically by the system when …
Privacy & firewall
Medium→
Formula.Firewall
Power Query's privacy firewall blocked a query because it would combine data from sources with different privacy levels.…
Medium→
Please rebuild this data combination
Power BI detected a potential privacy violation where data from one source might be sent to another. This error is relat…
Capacity errors
High→
The dataset exceeds the memory limit
The dataset is too large to fit within the memory allocated to your Power BI capacity tier. Power BI loads the entire da…
High→
Capacity is overloaded
The Power BI Premium capacity hosting this workspace has run out of resources. Refresh jobs are queued, throttled, or re…
Schema errors
Medium→
DM_GWPipeline_Gateway_DataTypeConversionError
A value retrieved from the data source could not be converted to the data type expected by the Power BI model. This typi…
High→
HRESULT: 0x80040E37
The Analysis Services or OLE DB provider cannot find the specified table or object. The hex code 0x80040E37 maps to the …
Tired of looking up error codes?
MetricSign monitors every dataset refresh and surfaces errors with root cause context — no manual investigation required. Free for one workspace.
Get started free →