Does power pivot refresh in sync with power query

I have a file that had an extensive power query transformation

And I essentially need to make a few different pivot tables using the PQ output to summarize some results

But I’m concerned that if I do that the pivot table will refresh before the power query output refreshes

If I use power pivot (which im unfamiliar with) Will this issue be avoided

I could just use power query to get the results I need in the desired format but my system is 32 bit and that would murder the memory since I’d have to run the same query 3-4 times and as I understand it power pivot is much easier on the memory for visualizations