Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

Power Query refresh error

Copper Contributor

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.

5 Replies
best response confirmed by heatheralaska (Copper Contributor)
Solution

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:

  1. Check all of the formulas in the query to make sure that they are referencing valid cells.
  2. Review any custom functions in the query to make sure that they are defined correctly.
  3. 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:

  1. Delete the query from Power Query Editor and recreate it from scratch.
  2. Copy the query to a new workbook and try to refresh it there.
  3. 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)

@heatheralaska 

If you open Power Query editor, on which step of the query this error appears?

@Sergei Baklan 

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!
Thanks! I got it to update.
1 best response

Accepted Solutions
best response confirmed by heatheralaska (Copper Contributor)
Solution

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:

  1. Check all of the formulas in the query to make sure that they are referencing valid cells.
  2. Review any custom functions in the query to make sure that they are defined correctly.
  3. 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:

  1. Delete the query from Power Query Editor and recreate it from scratch.
  2. Copy the query to a new workbook and try to refresh it there.
  3. 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)

View solution in original post