Forum Discussion
Difference between One drive refresh and Scheduled Refresh
Hi Thiyagu,
Based on my test, if you replace a PBIX file which has been imported into PBI with another PBIX file in onedrive, this will have no effect on the original PBIX or the loaded report. The data in the loaded report will be updated when data in data source is changed through gateway.
Regards,
Jimmy Tao
Follow up question:
If you host a file in SPO in a document library, does that also work or do you HAVE to use OneDrive?
Say I wanted to upload 3 Excel files, I know I can put them in OneDrive and connect.
What if I need to put them in a SPO team or group site...can I put them in the Document Library there and refresh off them just like it was One Drive?
Provided it is SharePoint Online (In the Microsoft Cloud, not hosted on-premise) You can host files in a SharePoint Library, and refresh them from there. In the SharePoint case, you'll set up refresh on the Dataset uploaded to Power BI, you specify a "Direct Connection" - no gateway needed, and store the Data Source Credentials (the login you use to SharePoint) then set up the refresh schedule. (Again maximum 8 refreshes in 24 hours, with a minimum of 30 minutes between refreshes.
The diference with OneDrive is that it updates hourly, and does not need to store credentials (it uses your Power BI login details to OneDrive) With SharePoint Online it needs the login credentials, and uses the Refresh schedule.
As a "rule of thumb" if the data is already in the cloud (SharePoint Online, OneDrive, Google Analytics, Salesforce Online etc. etc) no gateway is needed. Gateways are required if the data is held locally on-premise.
Hope this helps
Stuart