Power Query Problems

How to Fix Power BI Dataflow Cannot Save Power Query Changes

Camila MilosovichCamila Milosovich Oct 21, 2026 868 views

Question details

The user is unable to save Power Query transformations applied within Power BI Dataflows.

How to Fix Power BI Dataflow Cannot Save Power Query Changes
Product
Power BI Dataflows
Device & OS
not provided
Scenario
Editing data transformations in the Power BI service online and attempting to save the changes to a dataflow.
Observed behavior
The save operation fails to complete, potentially due to backend service issues, workspace capacity constraints, or a pending workspace upgrade.
Before you start

Ensure you have a stable internet connection and verify that your account has the necessary Edit or Admin permissions for the affected Power BI workspace.

Solution 1Recommended

Complete Pending Workspace Upgrades

Upgrading your Power BI workspace to the latest version often resolves background configuration and capacity issues that prevent saving.

Microsoft periodically releases backend updates for Power BI workspaces. If an upgrade is pending, certain dataflow operations like saving Power Query changes may be restricted until the upgrade is completed.

1
Check for notifications

Log into the Power BI service and navigate to your workspace. Look for an upgrade notification banner at the top of the screen.

2
Initiate the upgrade

Click on the upgrade prompt and follow the on-screen instructions to update the workspace.

3
Retry the save operation

Once the upgrade is complete, open your dataflow, make your Power Query changes, and try saving again.

Complete Pending Workspace Upgrades
Effective Fix: Many users report an immediate resolution of dataflow save failures right after applying the pending workspace upgrade.
Free Microsoft Office alternative

Looking for a Lightweight Alternative for Data Analysis? Try WPS Office

While Power BI handles complex cloud dataflows, WPS Office provides an exceptional, free alternative for everyday data analysis, spreadsheet management, and reporting. It offers powerful data processing capabilities offline and is highly compatible with Microsoft Office formats.

  1. 1. Download the software: Visit the official WPS Office website and download the free installer for your operating system.
  2. 2. Install WPS Office: Run the setup file and follow the quick installation prompts.
  3. 3. Open your datasets: Launch WPS Spreadsheet and seamlessly import your Excel or CSV datasets for immediate, offline analysis.
Fully compatible with Microsoft Excel (.xlsx), CSV, and XML formatsLightweight application that runs smoothly on all desktop and mobile devicesBuilt-in advanced formulas, pivot tables, and data visualization toolsFree to download and use with a highly familiar, intuitive user interface
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Power BI dataflow get stuck on saving?

Dataflows can get stuck during the saving process if there is a temporary Microsoft service outage, insufficient workspace capacity, or browser cache issues that prevent the necessary web requests from completing successfully.

Do I need a Power BI Pro license to open a support ticket?

Yes, standard free users are typically directed to community forums for help, while users with a Power BI Pro or Premium license have the ability to open direct support tickets at support.powerbi.com.

Can workspace permissions affect saving Power Query changes?

Absolutely. If your access level was recently downgraded from Contributor or Admin to Viewer, you will lose the ability to save modifications to any dataflows within that workspace.