Hi below is some code I've used before. But what I need is a way to refresh a PowerPivot or PowerQuery every hour unit 10pm.
I want to pull in our stores sales and have it refresh every hour in the background.
Then I want to send out emails. I have that code but need to automate calling the...