Forum Discussion
What is the difference between refreshing in Power Query Vs. refreshing the Report view
After refreshing Power Query and clicking "Load and Apply", Power BI Desktop refreshes the data again.
What is the difference between the two mechanisms?
Thank you
Tamir
Hello tamiribas , Hope you are doing good.
When you refresh in Power BI Desktop, the entire report data is updated from the data sources, applying all transformations, and impacting the complete data model and visuals, which is handy when you need the most recent data in your report.On the other hand, refreshing in Power Query Editor updates only the selected query during the data transformation phase, which is quite useful for testing and validating transformations without affecting the overall data model.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
2 Replies
Hello tamiribas , Hope you are doing good.
When you refresh in Power BI Desktop, the entire report data is updated from the data sources, applying all transformations, and impacting the complete data model and visuals, which is handy when you need the most recent data in your report.On the other hand, refreshing in Power Query Editor updates only the selected query during the data transformation phase, which is quite useful for testing and validating transformations without affecting the overall data model.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
Hi tamiribas
Refreshing in Power Query (PQ) refreshes the snapshot that you can work with within the PQ tool. It does not refresh the model itself. Therefore, when you click "Close and Apply," the system runs a refresh of the model/table that you modified.
In contrast, refreshing the front-end interface refreshes the model itself.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
