Forum Discussion
Expression error with data query
I'd suggest to check credentials in Data Source settings on this source.
Do you see your columns on Promote Headers step?
Please try again. It didn't work few hours ago, right now I repeated your Power Query again and it works
It looks like it was break in services.
- I am getting the same error in Excel, but it is due to the source data being downloaded (from web site data source).
Is there a way to ignore the error and complete downloading the rest of the data to the row?
I know it is the source as I am downloading the same fire weather data for specific times and only one time is generating the error. When I look at the .xml download it is returning data for the column that is erroring.
Thank you.I am getting the same error in Excel, but it is due to the source data being downloaded (from web site data source)
If the error is "[Expression error]. The column 'wxyz' of the table wasn't found" this means that somewhere in your current query code one (at least) step refers to a column named 'wxyz' that doesn't exist in the data Source (the Website you download from) at the time you Refresh the query
Is there a way to ignore the error and complete downloading the rest of the data to the row?
Maybe/Maybe not. Difficult to say without seeing your complete query code (post it if the following doesn't help)
When you create a query Power Query automatically creates a Change Type step after getting the data from an unstructured Source (i.e. a Website). That Change Type step "hard-codes" the column names (in the query code). For example, assume that when you create the query columns A, B, C, D exist in the data Source. Power Query auto. creates a Change Type step like:
= Table.TransformColumnTypes(Source,{{"A", Int64.Type}, {"B", type text}, {"C", type text}, {"D", type number}})If next time you Refresh the query column "C" doesn't exist in the data Source you'll get error "[Expression error]. The column 'C' of the table wasn't found"
Assuming a Change Type step exist in your current query edit the latter and delete that step...
- I am encountering the exact same issue! Stock quotes that I have used for several years has now stopped working. I've done nothing myself to the spreadsheet over the past week. Not sure if it is Google Drive or Excel
millerboyz Most probably Google, please check my previous post here.
- While my Google file appears to update correctly each time it is accessed, the Excel file continues to produce the error message when I attempt to refresh with data from Google.
