Power Query & Data Connections
27 articles
How to Fix “The process cannot access the file because it is being used” (PQ)
This error occurs when Power Query attempts to open, transform, or load data from an external…
Troubleshooting Power Query “Timeout” Errors on Large SQL Datasets
A Power Query SQL timeout error, such as Microsoft SQL: Execution Timeout Expired or DataSource.Error: The…
“Excel cannot find the data provider” for OData Feeds
The error "Excel cannot find the data provider" appears when connecting to or refreshing an OData…
“Expression.Error: The key didn’t match any rows in the table”
This error occurs in Power Query when an M-code step attempts to navigate to an object…
How to Resolve “Credential persistence” Errors in M365 Excel
“Credential persistence” errors occur when Microsoft 365 Excel cannot write, read, or maintain cached authentication tokens…
“Data Source.Error: Value was either too large or too small for an Int32”
This error occurs when Power Query or an underlying database driver attempts to load a number…
Troubleshooting SharePoint Folder Connection Failures in Power Query
A SharePoint folder connection failure in Power Query occurs when Excel cannot establish an authenticated link…
How to Fix Power Query “Formula.Firewall: Query references other queries”
The Power Query error Formula.Firewall: Query 'QueryName' (step 'StepName') references other queries or steps, so it…
“The download has failed” when Refreshing Excel Web Data
The error "The download has failed" appears when Excel attempts to refresh data using a web…
“DataFormat.Error: We couldn’t parse the input provided as a Date”
The error DataFormat.Error: We couldn’t parse the input provided as a Date occurs when Excel’s Power…
Troubleshooting “Information is needed regarding data privacy” Refresh Loops
The Power Query prompt warning that “Information is needed regarding data privacy” halts background calculation routines…
Power Query “Expression.Error: The column of the table wasn’t found”
The Power Query error Expression.Error: The column of the table wasn't found triggers when a data…