Forum Discussion
OneDrive and SharePoint auto-refresh
Hi Christophe ,
Yes correctly,but do remember if you update the file locally,you need first to make a refresh in sharepoint or onedrive to make the files updated in the cloud,then the refresh will be automatically executed in Service.
Note: Your dataset that connects to the file will be synchronized soon after the file on OneDrive, or SharePoint Online, is updated. Any visualizations based on the dataset are automatically updated too.
Here is a similar reference you can refer to:https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-csv-file-onedrive
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
You need to go to the settings for the Dataset you published (when you publish a report, the dataset gets published too), and click on Scheduled Refresh to add the times of day you want it to refresh. Since you are using cloud sources (OneDrive/Sharepoint), you don't need to worry about a Gateway. See this link for more details
https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh
If this works for you, please mark it as solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
mahoneypat thanks for the reply but this is not what I am looking for.
Scheduled refresh allows up to 8 refreshes a day. What I want is the OneDrive/SharePoint autorefresh that happens every hour.
I don't have much experience troubleshooting that refresh. However, another option is to set up a flow that has one hour recurrence and triggers your data set refresh.
Regards
Pat
That won't work mahoneypat . Flow based refreshes can be anytime you want, but it is limited to how many refreshes you can do - 8 per day for Pro, 48 per day for Premium. After that, just stop working until the next day.
Christophe See this article for configuring ONeDrive Refresh. - you still have to go into the settings to set it up.
edhans thanks for the reply and great point about Power Automate limitations.
The issue is that I don't even see OneDrive Refresh in the settings after I publish my pbix file. Could you tell me what method you used to connect to the Excel file when creating the pbix?
