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!
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,
Kelly
Hi v-kelly-msft / Christophe
My xlsx files are all stored in Sharepoint of different libraries.
I don't think this is an issue and the pbix file is also stored in SharePoint.
Could you explain more on how to use the service to connect to the pbix file so that I can have auto-update, at least once in an hour?