Forum Discussion

EBA38's avatar
EBA38
Regular Visitor
7 months ago
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...
Need Help
  • cengizhanarslan's avatar
    cengizhanarslan
    7 months ago

    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
krishnakanth240's avatar
krishnakanth240
Icon for Super User rankSuper User
7 months ago

Hi EBA38 

This happens when we have import mode. When you edit Power Query, Power BI will fully reload for the transformed queries. So, you can do transformations in the dataflow or Azure SQL instead of Desktop. Also, we can replace DirectQuery mode or composite mode instead import and give a try.