Refresh Power Query and Power Pivot Data Model at once

[M001]

Hi,

I am using Power Query + Power Pivot Data Model to help me run a projection model in various scenarios where I will have to change my data input frequently. I realize my data output will not reflect the latest change if I just refreshed at Excel >> Data tab >> Refresh All, the data output will only reflect correctly after I ran another refresh at Power Pivot Data Model >> Home >> Refresh All

I would like to know if there is any alternative where I could just run Refresh once for both (Power Query + Power Pivot Data Model) without going thru the refresh button in Power Pivot Data Model or create VBA button to run at Excel page?

Thank you!!

M

[Anonymous]

Hi @M001 ,

You can refresh both Power Query and Power Pivot Data Model at once by using the "Refresh All" button in the Excel Data tab.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[M001]

Hi Stephen, 

As mentioned in my post, it doesnt work. Thank you

Regards,

M