Show notes
As always I thoroughly enjoyed chatting with my guest. Thank you Celia.
Celia has a very different backstory to many guests, such a twisting tale of chance and hard work coupled with a dedication to automate everything and find a better way.
Check out Celia's favourite and extremely useful blog post on allowing a single refresh when combining loaded tables with Pivot tables
https://solveandexcel.ca/2020/09/11/enable-background-refresh-property-in-power-query-in-excel/
And her most popular here
https://solveandexcel.ca/2020/10/23/how-to-change-the-display-language-in-excel/
You can also find Celia here:
https://www.linkedin.com/in/celiajordaoalves/
The Dataflow Connector code I mention briefly is = PowerPlatform.Dataflows(null)