Power Query Problems

Resolve Excel Power Query Function Argument Refresh Errors

Olivia MillerOlivia Miller Nov 12, 2026 869 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open Power Query Editor

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.

2
Locate the first error step

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.

3
Review the formula bar

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.

4
Check custom functions and parameters

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.

5
Refresh and validate the query

Select Home > Refresh Preview in Power Query Editor, then choose Home > Close & Load or Close & Load To to return the corrected results to Excel.

Use the first failing step: If the original query remains damaged, copy valid Applied Steps into a new blank query or recreate the query one step at a time to isolate the invalid function call.
Free Microsoft Office alternative

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. 1. Install WPS Office: Download and install WPS Office, then open the affected Excel workbook from the WPS Spreadsheet start screen.
  2. 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. 3. Save a compatible copy: Select Menu > Save As and choose Excel 2007-365 Workbook (*.xlsx) to save an editable Microsoft Excel-compatible copy.
Open and edit compatible .xlsx and .xls workbooks with a familiar spreadsheet interface.Use a lightweight, free Office alternative when Power Query is not required for the task.Review formulas, tables, and worksheet data while preparing a workbook for migration.Maintain compatibility with Microsoft Excel .xlsx and .xls file formats.
microsoft office alternative - wps office

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.