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
Thank you v-kelly-msft for the help.
I successfully tested that if I use Power BI service to import an Excel file from OneDrive or SharePoint, then the OneDrive refresh is set up. However that doesn't allow me to transform the data.
To transform the data, I have to get the Excel file from OneDrive or SharePoint to Power BI desktop, then upload to Power BI service. In this case, the OneDrive refresh is not enabled and only scheduled refresh is available.