Forum Discussion

kabra_ashish's avatar
kabra_ashish
Helper III
6 years ago
Solved

Customized table refresh sequence

Is it possible to customise the refresh sequence of the tables? In other words defining the sequence as to which tables should be refreshed 1st and so on?   I have 7 tables in my report. And it ref...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi kabra_ashish ,

     

    Currently, go to File -> Options and settings -> Options ->Data Load, turn off the option "Enable parallel loading of tables", you can refresh tables one by one. While it is not supported to customize table refresh sequence in Power BI currently. You can post your new idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas , add your comments there to improve Power BI and make this feature coming sooner.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards,

    Amy

     

    Community Support Team _ Amy

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

JarroVGIT's avatar
JarroVGIT
Resident Rockstar
6 years ago

Typically, PowerBI determines the dependencies between multiple queries and determines the order of loading based on that. Is there a specific reason why you want your tables to be loaded in a specific order? If there are dependencies, PBI should take those into account automatically as far as I know 🙂

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

kabra_ashish's avatar
kabra_ashish
Helper III
6 years ago

Thanks djerro123!

 

The reason I am looking for this is because I have a table created for the refresh timestamp. I want this table to be refreshed at the end after all the tables are refreshed so that I get the exact refresh date / time. 

 

Let's assume there are now 5 more tables to be included in the report. In this case it will not give me exact timestamp of refresh completed as this table was refreshed somewhere in the middle of all these tables. 

  • JarroVGIT's avatar
    JarroVGIT
    Resident Rockstar
    6 years ago

    Well that is valid. I had a little fun playing with creating M tables vs DAX tables and see what the result would be, but it seems that the DAX tables are even executed earlier in my case. Anyway, I found a method on Youtube for you, that should work.

    https://youtu.be/YfdypVSYb9c 

     

    Kind regards

    Djerro123

    -------------------------------

    If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

    Keep those thumbs up coming! 🙂