Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Order refresh tables

Hi, 

 

Is there a way to find out the order of refresh of the tables when manual or scheduled refresh?
I have a table that includes another table (appended) and does the order of refresh important to make sure that the appended table is refresh first before the "main table"??

--> If the main table is refreshed first and than the appended table, the main table does not take into account the refresh of the appended table?

Need Help
Show and Tell
Tips and Tricks
  • v-xiaotang's avatar
    v-xiaotang
    4 years ago

    Hi Anonymous 

    Thanks for reaching out to us.

    >> If the main table is refreshed first and than the appended table, the main table does not take into account the refresh of the appended table?

    Generally speaking, if it is in Import mode, dataset will be refreshed in both the main table and the appended table during scheduled refresh or manual refresh; if it is in DQ mode or LC mode, when the data in the table changes, dataset will be refreshed. Therefore, if the import mode is used, then you can control the time of scheduled refresh, so that the scheduled time is after the main table data changes and before the attached table data changes.

    Data refresh in Power BI - Power BI | Microsoft Docs

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    4 years ago

    Hi Anonymous 

    Thanks for reaching out to us.

    >> If the main table is refreshed first and than the appended table, the main table does not take into account the refresh of the appended table?

    Generally speaking, if it is in Import mode, dataset will be refreshed in both the main table and the appended table during scheduled refresh or manual refresh; if it is in DQ mode or LC mode, when the data in the table changes, dataset will be refreshed. Therefore, if the import mode is used, then you can control the time of scheduled refresh, so that the scheduled time is after the main table data changes and before the attached table data changes.

    Data refresh in Power BI - Power BI | Microsoft Docs

     

    Best Regards,

    Community Support Team _Tang

    If this post helps, please consider Accept it as the solution to help the other members find it more quickly.