Hi all!
Wanted to see whether anyone has toyed around with combining Power Query into a modular workbook.
We've actually delved into it quite a bit, as it provides a lot of power around pulling in operational metrics, even optimising how we run consolidations in a modular workbook.
Will provide an example shortly, just keen to see if anyone has had a play around.
Thanks all!