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.

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! 🙂