Refreshing Power Query / Power Pivot

[DickyMoo]

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]

Hey Rich,

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

 

[DickyMoo]

That is what I shall do, thank you Ken