Go to the Data tab on the Excel Ribbon, and select the Connections command. The Workbook Connections dialog box opens. Select the data connection you want to work with and then click the Properties button.
Refresh Every X Minutes
Refresh Data When Opening the File
Preventing Refresh All
2.subscription against the power pivot report
I recommend you could publish to service and set Subscriptions.
Best Regards, Community Support Team_ Yalan Wu If this post helps, then please consider Accept it as the solutionto help the other members find it more quickly.