Forum Discussion
Hourly refresh automation not possible
Hello. My IT admin told me I now have access to powerBI professional. I tried to change the scheduled refresh to an hourly rate. My data source is a excel file which is connected via on premise d...
Hi phyten,
In your scenario, you can upload your excel file to OneDrive or SharePoint Online only, and then use this excel file as datasoure, then the data will refresh hourly and it will refersh automatically. For the details, please refer to the link below.
https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-data/
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-onedrive-business-links/
Regards,
Charlie Liao