@@AuroraS934 thank you, Aurora. Glad that it helped. Another common issue is pivot tables only refreshing on the second refresh all. If you have that type of issue, it can be solved another way.
Thank you for this wonderful video. I do have a situation that I can’t find a solution. What I’m trying to do is find a way to highlight all changes that happen between a power query refresh. I can add more detail but I don’t think it is appropriate in commenting on this video
That's a simple wish with not so simple solution. Depending if your scenario, there can be multiple ways of solving it. None is very straight forward. I'll add some resources in the next comments for your to try.
Excellent example on leveraging query dependency to force power query to refresh in the order that you need! Thanks Celia!👏
@@AuroraS934 thank you, Aurora.
Glad that it helped.
Another common issue is pivot tables only refreshing on the second refresh all. If you have that type of issue, it can be solved another way.
Great exposition! I have always wondered what was driving the need for two refresh alls. Thanks.
You're welcome! Glad that it helped understanding.
Thanks. That was important!!!
@@johnborg5419 glad that you think so, John! Thank you :)
Great explanation, Celia. Many thanks!
Thank you, Ian, for watching and leaving your feedback. :)
Great video 👍. Thank you Celia and look forward to more!
Thank you, @kebincui. Glad that you found it valuable. Next one is in the making. 😉
This is utterly useful, thank you so much!
@@zuzanasmekalova4632 glad that it helped. Thank you for watching and leaving your feedback.
Really really useful - great concepts here. Thank you.
Thank you, Janice! I appreciate you watching and leaving your feedback. It made my day. :)
muito bom! Obrigado Celia
Obrigada eu, David! :)
Thank you for this wonderful video. I do have a situation that I can’t find a solution. What I’m trying to do is find a way to highlight all changes that happen between a power query refresh.
I can add more detail but I don’t think it is appropriate in commenting on this video
That's a simple wish with not so simple solution. Depending if your scenario, there can be multiple ways of solving it. None is very straight forward.
I'll add some resources in the next comments for your to try.
exceleratorbi.com.au/self-referencing-tables-power-query/
th-cam.com/video/6mPYAmiu80g/w-d-xo.htmlsi=Jq9dubj--V2XOejP
th-cam.com/video/AijmQ5uuwGw/w-d-xo.htmlsi=idQUpUYFUza3pQjg
Eureka!!
Yay! Thank you, Antony. And congratulations for being part of the resilient group. I hope the video was helpful to you.
it was. I liked it @@CeliaAlvesSolveExcel
EUREKA!!!!
Awesome! Thank you for watching till the end, Christy. I hope it was helpful to you.