Resolve Excel Power Query Function Argument Refresh Errors
Question details
The user needs to fix a Power Query refresh error caused by a function receiving an argument even though it expects zero arguments.
- Product
- Microsoft Excel Power Query
- Device & OS
- not provided
- Scenario
- An existing query fails during refresh, while a newly created query works correctly. The user needs to identify and repair the damaged query step or function call.
- Observed behavior
- Power Query displays the error '[Expression.Error] One argument was passed to a function that expects zero arguments' during refresh.
Open the workbook in Excel and note the query name and refresh error message. In Power Query Editor, review the Applied Steps list and identify the first step that shows an error before changing formulas or custom functions.
Correct the Power Query step that passes an unexpected function argument
Use this method when the original query opens in Power Query Editor and the failing step can be identified.
The error usually occurs when a function defined with no parameters is called with a value, or when a custom function, parameter, formula, or source reference has been altered. Start with the first failing step because later errors may only be consequences of that original problem.
In Excel, select the Data tab, choose Get Data, and click Launch Power Query Editor, or select Data > Queries & Connections and open the affected query.
In Power Query Editor, select the query and inspect the Applied Steps pane from top to bottom. Click each step until the preview displays the expression error.
With the failing step selected, inspect the formula bar and look for a function call that includes an unexpected value or argument. If the formula bar is hidden, enable it from the View tab.
Open the query or function referenced by the failing step and compare its definition with its invocation. Remove the extra argument, supply the required value, or correct the parameter and source reference as appropriate.
Select Home > Refresh Preview in Power Query Editor, then choose Home > Close & Load or Close & Load To to return the corrected results to Excel.
Recreate the query to isolate a damaged function or step
Use this option when the error persists or the original query contains corrupted, unclear, or difficult-to-edit steps.
Edit and manage compatible Excel workbooks with WPS Office
WPS Office does not repair Microsoft Excel Power Query functions or run Power Query refreshes, but it provides a free, lightweight alternative for opening, editing, reviewing, and migrating compatible Office workbooks. Its familiar spreadsheet interface helps users continue working with files while preserving common Excel formats.
- 1. Install WPS Office: Download and install WPS Office, then open the affected Excel workbook from the WPS Spreadsheet start screen.
- 2. Review workbook data: Use the Spreadsheet ribbon to inspect worksheets, formulas, tables, and source data that may need to be migrated from the Excel file.
- 3. Save a compatible copy: Select Menu > Save As and choose Excel 2007-365 Workbook (*.xlsx) to save an editable Microsoft Excel-compatible copy.

Frequently Asked Questions
What causes the Power Query error that says one argument was passed to a function expecting zero arguments?
It generally means a function defined without parameters is being called with an argument. It can also result from a changed custom function, parameter, formula, or source reference in one of the query steps.
How can I find the exact Power Query step causing the refresh failure?
Open the query in Power Query Editor and select the Applied Steps from top to bottom. The first step whose preview shows the Expression.Error is usually the step that needs correction.
What should I check in a Power Query custom function?
Compare the function definition with the way it is called. Check whether the definition accepts zero or more parameters, whether the invocation supplies the correct number of arguments, and whether any parameter value is missing or incorrectly referenced.
Why does a newly created query work while the original query fails?
The original query may contain a damaged transformation step, outdated source reference, or invalid function invocation. A new query often works because it creates fresh source and navigation steps without the damaged expression.
Can WPS Office refresh Microsoft Excel Power Query queries?
No. WPS Office can open and edit many Excel workbooks, including .xlsx and .xls files, but it does not directly repair or run Microsoft Excel Power Query refresh operations.




