Refresh Power Query and Power Pivot Data Model at once

Question

Hi,&nbsp;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 &gt;&gt; Data tab &gt;&gt; Refresh All, the data output will only reflect correctly after I ran another refresh at Power Pivot Data Model &gt;&gt; Home &gt;&gt; Refresh All&nbsp;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?&nbsp;&nbsp;Thank you!!M

anonymous · Answer

Hi&nbsp;M001&nbsp;,
&nbsp;
You can refresh both Power Query and Power Pivot Data Model at once by using the "Refresh All" button in the Excel Data tab. 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Best Regards,
Stephen Tao
&nbsp;
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;

m001 · Answer

Hi Stephen,&nbsp;&nbsp;As mentioned in my post, it doesnt work. Thank you&nbsp;&nbsp;Regards,M

Forum Discussion

Refresh Power Query and Power Pivot Data Model at once

2 Replies

Related content

Excel Power Query Refresh

Refresh Direct Query not refreshing

Power Bi refresh

Power Query dates

Data transform using power query