Is it possible to automatically refresh pivot data extracted from PowerBI?

[nathanpere]

Hi everyone

I've got an excel sheet with data sourced from PowerBI which is utilised daily however, I'm having to click "Refresh All" under Data every time i use it.

Is there anyway to automate the data refresh?

The PowerBI data is updated once every morning, if I could align my data to refresh around the same time that would be great.

Many Thanks!