PDA

View Full Version : Refreshing Power Query / Power Pivot



DickyMoo
2016-12-06, 08:42 PM
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

Ken Puls
2016-12-07, 04:16 PM
Hey Rich,

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

DickyMoo
2016-12-07, 08:39 PM
That is what I shall do, thank you Ken