none
Power Query Refresh RRS feed

  • Question

  • Hi All,

    I just want to know about power query refresh feature.

    Suppose I have a master file where I have imported multiple file into multiple table and did calculation using power query.

    For example :

    Table 1 linked to table 2

    Table 2 linked to table 3

    Table 3 to final table.

    Now I want to know if I am refreshing only final Table then ,power query refresh feature also refresh other table calculation also which is linked to final table or we have to refresh all query tables one by one ?

    Please suggest.

    Regards,

    Rajender


    Rajender

    Tuesday, December 19, 2017 3:15 PM

Answers

  • Power Query keeps track of dependencies and is very smart about updating other queries in the correct order.

    Try it out - refresh your final query and with the query pane open you'll see the other queries getting updated automatically in the process.Note that you can also put queries in a folder and right-click the folder to choose refresh.  It will update the queries in the folder and any others required (even if they are not in the folder).

    Dale

    • Proposed as answer by Dale Hohm Wednesday, December 20, 2017 2:21 PM
    • Marked as answer by AskQuery1984 Wednesday, December 20, 2017 3:23 PM
    Tuesday, December 19, 2017 8:36 PM

All replies

  • Power Query keeps track of dependencies and is very smart about updating other queries in the correct order.

    Try it out - refresh your final query and with the query pane open you'll see the other queries getting updated automatically in the process.Note that you can also put queries in a folder and right-click the folder to choose refresh.  It will update the queries in the folder and any others required (even if they are not in the folder).

    Dale

    • Proposed as answer by Dale Hohm Wednesday, December 20, 2017 2:21 PM
    • Marked as answer by AskQuery1984 Wednesday, December 20, 2017 3:23 PM
    Tuesday, December 19, 2017 8:36 PM
  • Hi Dale,

    Thanks a lot for your valuable feedback.

    Regards,


    Rajender

    Wednesday, December 20, 2017 7:41 AM
  • Is there a way to control this refresh? My first query is for bringing external data into the file, and then I have several secondary queries reffering the primary one to modify data for use intarnaly in the file. Now when I refresh my secondary queries, they also seem to triger the first one to refresh and pull "outside data" into the file, even though it is not desired and I have deselected "include this query in Refresh All" under properties.

    Monday, October 8, 2018 7:07 AM
  • there is incremental refresh in Power BI Premium, but that's about all the control that we have at this moment. If there are any query dependencies, then the top level will need to be refreshed first. This works amazingly for queries against a database, since you'll take advantage of Query Folding, but for files (Excel or flat files) is not the best performance when you're dealing with A LOT of data.
    Tuesday, October 9, 2018 6:31 AM