I'm trying to understand better how PowerQuery works and if is maybe better than what I am currently doing.

Currently I have a Workbook with an OLAP external connection to our accounting data. And I can pull in a value from that connection with a CubeValue formula. And I am pulling a lot of data where the file size is now almost 30MB (drops to 8 if convert all the formulas to values)

The Cubeformula takes 6 inputs, ie, CubeValue("MyConnection", Site, Mode, Item, Date, FactPeriod)

So in trying to understand better, I made 5 PowerQueries, 1 for Site, Mode, Item, Data, and FactPeriod. That data then loads each one into a separate worksheet.

But I'm not sure if this is any better than what I am doing. And how to then actually pull a Cubevalue for a Specific Date or Item from those worksheets.

Is what I'm doing now with using the CubeValue formula's sort of the same thing as the PowerQuery?

Just trying to understand better.

Thank you,
PT