Refreshing Power Query / Power Pivot

DickyMoo

New member
Joined
Mar 7, 2016
Messages
27
Reaction score
0
Points
0
Location
London
Hello,

I have a Power Pivot model fed by Power Query (Excel 2016), what is the best way to refresh it?

I would usually just refresh any of the pivot tables, but I have a cube formula to a table that has no associated pivot, and that does not update when I refresh a pivot.

Will refreshing the PQ queries guarantee the PP model and pivots are refreshed, or vice versa?

Thank you

Rich
 
Hey Rich,

Why not just use the Data --> Refresh All button? That should refresh everything for you in one shot.
 
Back
Top