Forum Discussion
Solved
reload data after power query edit
Hi, I have a dataflow that pulls its data from Azure SQL, then feeds my semantic model, and finally my report. When I download the PBIX, it is 900 MB with the data. I open the PBIX in Power BI Desk...
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
AshokKunwar
Continued Contributor
Continued ContributorHii @EBA38 ,
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!