Power Query Problems

Troubleshoot Excel Power Query Refresh Errors from Dynamics 365

Muhammad TalhaMuhammad Talha Nov 12, 2026 868 views

Question details

The user needs to diagnose refresh failures in Excel workbooks connected to Microsoft Dynamics 365, especially when similar reports and query settings work in other files.

Troubleshoot Excel Power Query Refresh Errors from Dynamics 365
Product
Microsoft Excel Power Query with Microsoft Dynamics 365
Device & OS
not provided
Scenario
A workbook connected to a Dynamics 365 report or data source fails to refresh while another visually similar workbook refreshes successfully.
Observed behavior
Power Query refresh or preview fails for specific workbooks, customers, reports, or query configurations even though comparable files appear to use the same data source.
Before you start

Open one failing workbook and one working workbook side by side. Record the exact refresh error, source URL, report or customer identifier, query parameters, and the time of the failure before changing credentials or query settings.

Solution 1Recommended

Compare the failing and working Power Query configurations

Use this approach when one Dynamics 365-connected workbook fails but another similar workbook refreshes correctly.

Visually similar reports can use different data source URLs, parameters, filters, credentials, privacy levels, or customer identifiers. Comparing the query configuration usually reveals the difference that causes the refresh failure.

1
Inspect the query source

In Excel, open the failing workbook and select Data > Queries & Connections. Right-click the affected query, choose Edit, and review the Source step in Power Query Editor for the Dynamics 365 URL, report, and account or customer identifiers.

2
Compare query settings

Compare the failing query with a working workbook, including query parameters, filters, applied steps, credentials, privacy levels, and report configuration. In Power Query Editor, select Home > Advanced Editor when you need to compare the underlying M code.

3
Test the Dynamics 365 report directly

Sign in to Dynamics 365, open the source report, and refresh it there first. Confirm that the affected customer, account, or report returns valid data rather than an empty, invalid, or unusually large result.

4
Refresh the Power Query preview

Return to Power Query Editor and select Home > Refresh Preview. Review the first step that fails and open the error details to identify whether the problem is the source, parameters, filtering, authentication, or returned data.

Check the exact error scope: If only certain customers or reports fail, test those identifiers separately. Empty or unusually large results can cause behavior that differs from a normal successful refresh.
Free Microsoft Office alternative

Use WPS Office for compatible workbook editing and review

WPS Office is a free, lightweight alternative for opening, reviewing, and editing Excel workbooks when you need a familiar spreadsheet interface and smooth migration. It supports common Microsoft Office formats, including XLSX, but Microsoft Dynamics 365 Power Query refresh connections and their source-specific authentication must still be managed in Excel or the Dynamics 365 environment.

  1. 1. Install WPS Office: Download and install WPS Office, then open the application from your desktop or Start menu.
  2. 2. Open the workbook: Choose Spreadsheet > Open, select the XLSX workbook, and review its sheets, formulas, tables, and visible report results.
  3. 3. Inspect workbook content: Use the Data, Formulas, and Review tabs to examine filters, formulas, and report content. Power Query refresh controls and Dynamics 365 authentication must be handled in Microsoft Excel.
  4. 4. Save in Excel format: Select Menu > Save As, choose Excel 2007-365 (*.xlsx), and save a copy when you need to preserve compatibility with Microsoft Excel.
Open and edit XLSX workbooks with a familiar spreadsheet interfaceReview formulas, filters, tables, and report layouts in a lightweight applicationMaintain compatibility with Microsoft Excel XLSX files during migrationUse WPS Office for everyday workbook editing while troubleshooting Dynamics 365 connections in Excel
microsoft office alternative - wps office

Frequently Asked Questions

Why does one Excel workbook refresh Dynamics 365 data while another similar workbook fails?

The workbooks may use different source URLs, report or customer identifiers, query parameters, filters, privacy levels, credentials, or underlying report definitions. Compare the Source step and query settings in Power Query Editor rather than relying on the visible report layout.

How can I refresh Dynamics 365 credentials in Excel Power Query?

Go to Data > Get Data > Data Source Settings, select the affected Dynamics 365 source, choose Clear Permissions, and then use Edit Permissions to sign in again with an account authorized to access the report and its data.

What should I check if the Power Query preview returns no data?

Refresh the source report directly in Dynamics 365 and test the affected customer, account, or report identifier. Check filters and parameters for invalid values, and confirm that the result is not empty or unusually large.

Where can I find the specific cause of a Power Query refresh failure?

In Excel, open Data > Queries & Connections, edit the query, and select Home > Refresh Preview. The first failed applied step and its error details often identify whether the problem involves the source, authentication, parameters, filtering, or returned data.

Can WPS Office refresh a Microsoft Dynamics 365 Power Query connection?

WPS Office can open and edit compatible XLSX workbooks, but Dynamics 365 Power Query refresh and source-specific authentication should be performed in Microsoft Excel or the Dynamics 365 service.