Forum Discussion
reload data after power query edit
Power BI Desktop is forced to fully re-materialize the table locally after any Power Query change, even if the data ultimately comes from a dataflow and even if you “just tweaked something small”.
Best practice: Do NOT edit Power Query in the PBIX
If the data comes from a dataflow:
- Do all transformations in the dataflow
- Keep the PBIX as thin as possible
- Treat the PBIX as semantic + visuals only
Continued ContributorHii EBA38
Here are the best workarounds to bypass the "2-hour reload" and get back to developing your report
1. Use "Enable Load" to Work on Logic Only
If you are only editing the logic (adding columns, filtering, etc.) and don't need the 900 MB of data locally while you work, you can "unhook" the table from the local model.
- Right-click your table in the Power Query (left pane).
- Uncheck "Enable Load".
- Click Close & Apply. Power BI will now only save the metadata/instructions. When you are ready to publish, check "Enable Load" again. Note: This will temporarily break visuals in Desktop, but it stops the 2-hour reload.
2. Implement a "Development Filter" (The "Range" Trick)
This is the most professional workaround. You create a parameter that limits the data while you are in Desktop, then remove the limit once it's in the Service.
In Power Query, go to Manage Parameters > New.
Create a parameter named IsDesktop (Type: True/False, Current Value: True).
On your Fact table, add a filter step (e.g., Filter Date to the last 1 day).
Edit the M-code of that filter step in the formula bar:
= Table.SelectRows(Source, each if IsDesktop then [Date] > #date(2026, 1, 1) else true)
Now, Power BI Desktop only loads a few MBs of data. When you publish to the Service, change the parameter to False to load the full 900 MB.
3. Disable "Allow data preview to download in the background"
Power BI Desktop tries to be helpful by downloading data in the background to show you previews. For a 900 MB file, this creates a massive bottleneck.
- Go to File > Options and settings > Options.
- Under Current File, go to Data Load.
- Under Background Data, select "Never allow data previews to download in the background".
- Clear your Cache in the Data Load settings under Global while you are there.
4. Connect via the XMLA Endpoint (Large Models)
Since you are using a 900 MB semantic model, you may have Power BI Premium (or Fabric). Instead of downloading the PBIX and reloading data, use Tabular Editor to connect via the XMLA endpoint. You can edit measures and metadata without ever having to "Reload" the data locally.
If one of these methods helps you bypass the 2-hour loading screen, please mark this as the "Accepted Solution" to help others with large dataflow models!
Hi, thanks for your message.
in the 1.2 when I uncheck "Enable Load" I have a messsage : (I translate in English the message is in French) WARNING: POSSIBLE DATA LOSS
Disabling load will remove the table from the report, and any visuals that use these columns will break.
thanks
v-veshwara-msftCommunity Support
Hi EBA38 ,
Thank you fro the update.
The warning you are seeing when disabling Enable load is expected. In that state, Power BI removes the table from the local model, which is why visuals break. This option is mainly intended for intermediate or staging queries that support other transformations but are not meant to be part of the final model.
Managing query refresh - Power BI | Microsoft LearnIn your scenario, since the query represents a main table used by the semantic model and report visuals, disabling Enable load is not an ideal long term solution. While it can be used temporarily during development to avoid a full reload, it does not address the underlying behavior.
As highlighted earlier by others in this thread, the recommended approach is to avoid Power Query edits in the PBIX for large Import models and instead apply transformations in the dataflow or at the Azure SQL source. Keeping the PBIX focused on the semantic model and visuals helps avoid repeated full re loads in Power BI Desktop.
Hope this helps.
Please reach out for further assistance.
Thank you.