Solved: Customized table refresh sequence

kabra_ashish · ‎01-03-2020

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 refreshes the tables based on ascending order in which tables were first imported. I would like to have the first 4 tables refreshed the usual way and then jump on to the 7th table and then 5th, 6th.

Any help here will be highly appreciated.

v-xicai · ‎01-05-2020

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.

View solution in original post

dang · ‎09-23-2022

This is super awesome and happy to report it appears this functionality has been more recently added. Following @v-xicai 's info, I turned off parrallel loading. Then, I went into the query editor and reordered my queries in the list by dragging and dropping. My results show that the tables refresh in descending order in alignment with list postion in the query view.

v-xicai · ‎01-05-2020

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 · ‎01-06-2020

Thank you Amy!

I have posted this as an idea titled "Customise table refresh sequence".

JarroVGIT · ‎01-03-2020

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

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

kabra_ashish · ‎01-03-2020

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 · ‎01-03-2020

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.