APQ16 | High speed Data Refresh | Table.Buffer | Advanced Power Query

[@paspuggie48]

Great example of Table.Buffer, something I've never exploited but after this video I really need to apply it more often in my solutions. Thank you for sharing and explaining it in a simple way!

[@aaaexcelenglish]

Thank you for your comment 👍

[@warrenanderson412]

Go to the 4:50 minute Mark to review the Table Buffer. You Are Welcome😊

[@cablegurl328]

Thank you for the information! I will include the Table Buffer in my report - your assistance has been instrumental in enhancing my efficiency and productivity!

[@aaaexcelenglish]

Happy to hear so 👍

[@leetran8328]

look forward your next video, it's awesome

[@aaaexcelenglish]

Thank you.. soon 👍

[@romulusmilea2747]

This is an interesting video, thank you ! I think you should have explained also the disadvantages of using Table.Buffer function, people must know it is not universally advantageous. Table.Buffer uses a certain amount of memory (not entire memory), if that amount is not sufficient (for very large amount of data, i.e. tens of thousands of rows + tens of columns at least), then data on top of allocated memory will be written on hard drive, which could make the reading/refreshing VERY slow, so the apparent advantages are gone. I guess that very fast hard disks (such as SSD) could not have this issue, but it shall be trialled. Thank you !

[@paulaparo1583]

Outstanding! Thank you.

[@aaaexcelenglish]

You’re welcome ☺️

[@KuldeepSingh-nq1vi]

Awesome Video, I got something new.. Keep creating more videos... ❤

[@aaaexcelenglish]

Thank you, will do my best 👍

[@jawadahmadehssan6251]

Very useful. Thank you

[@aaaexcelenglish]

Most welcome 🙏

[@kebincui]

super video, Thanks

[@aaaexcelenglish]

You’re welcome

[@Linhftu]

Thank you very much, Sir!

[@aaaexcelenglish]

My pleasure

[@eduardomunoz2764]

great video, greetings and thanks Master.

[@aaaexcelenglish]

You’re most welcome dear

[@yousrymaarouf2931]

Fantastic

[@aaaexcelenglish]

Thank you 🙏

[@mcwahaab]

Thanks as always. A quick one. What should we do if the refresh time in the PQ Editor is taking too long? This is happening to me right now and I have so many qurries in one sheet

[@newidentity9299]

Thank you

[@aaaexcelenglish]

Most welcome 🙏

[@rangs1966]

super sir

[@aaaexcelenglish]

Thank you 🙏

[@hendrag593]

So, if we notice there is some delay in our query, we use Table.Buffer then . Thanks

[@aaaexcelenglish]

Exactly 👍

[@agostinhosubtil569]

Thanks

[@aaaexcelenglish]

Welcome 🙏