Forum Discussion
Power Query refresh error
My first Power Query and I had it up and running and refreshing but now something must have changed I get the error: We couldn't refresh the connection 'Query - Staff_Budget_Sheets' Here's the error message we got: [Expression.Error] 1 arguments were passed to a function which expects 0.
I tried making a whole new query, and that worked but still this new one will not refresh either.
Hi heatheralaska,
the error message [Expression.Error] 1 arguments were passed to a function which expects 0 indicates that Power Query is trying to call a function with one argument, but the function only expects 0 (zero) arguments.
This can happen for a few reasons:- A formula in the query is referencing an empty cell.
- A custom function in the query is not defined correctly.
- A step in the query is trying to perform an operation on a single value, but the value is missing.
To troubleshoot this error, you can try the following:
- Check all of the formulas in the query to make sure that they are referencing valid cells.
- Review any custom functions in the query to make sure that they are defined correctly.
- Look at the steps in the query to see if any of them are trying to perform an operation on a single value, but the value is missing. If so, you can try to fill in the missing value or remove the step from the query.
If you are still unable to resolve the error, you can try the following:
- Delete the query from Power Query Editor and recreate it from scratch.
- Copy the query to a new workbook and try to refresh it there.
- Repair your Excel installation.
Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.If the post was useful in other ways, please consider giving it Like.
Kindest regards,
Leon Pavesic
(LinkedIn)
Hi heatheralaska,
the error message [Expression.Error] 1 arguments were passed to a function which expects 0 indicates that Power Query is trying to call a function with one argument, but the function only expects 0 (zero) arguments.
This can happen for a few reasons:- A formula in the query is referencing an empty cell.
- A custom function in the query is not defined correctly.
- A step in the query is trying to perform an operation on a single value, but the value is missing.
To troubleshoot this error, you can try the following:
- Check all of the formulas in the query to make sure that they are referencing valid cells.
- Review any custom functions in the query to make sure that they are defined correctly.
- Look at the steps in the query to see if any of them are trying to perform an operation on a single value, but the value is missing. If so, you can try to fill in the missing value or remove the step from the query.
If you are still unable to resolve the error, you can try the following:
- Delete the query from Power Query Editor and recreate it from scratch.
- Copy the query to a new workbook and try to refresh it there.
- Repair your Excel installation.
Please click Mark as Best Response & Like if my post helped you to solve your issue.
This will help others to find the correct solution easily. It also closes the item.If the post was useful in other ways, please consider giving it Like.
Kindest regards,
Leon Pavesic
(LinkedIn)- Thanks! I got it to update.
If you open Power Query editor, on which step of the query this error appears?
I know so little about what I am doing...
I make the power query and save it to a worksheet
The power query is drawing information from a folder held in our company dropbox
I had been able to just use Data - Refresh and it would pull new information from the sheets in the folder that the staff were updating. Until it did not and now gives this error.
- I got it to update!
