12-03-2018 12:17 AM
I stored my data on someone else's OneDrive but when I checked Refresh History I get nothing. Am I suppose to see the refresh history for the Hourly updates given that the files are in OneDrive.
Or does this only work if I store data on my OneDrive not somebody elses?
12-03-2018 11:18 PM
Has the file in onedrive been updated? If the file is not updated in onedrive, power bi will not refresh the content automatically.
12-05-2018 08:41 AM - edited 12-05-2018 08:43 AM
It was updated and from what I read it's supposed to update around after an hour, but a day had passed but nothing happened when I check the Refresh History there was no entry in there that suggest that an automatic upadted had happened. I also check the Datasource Credentials but why is it though that everytime I check the Datasource Credential it's always showing as Anonymous whereas I did Signin via OAuth2.
12-05-2018 08:46 AM
Did you set the schedule refreshes? That needs to be set still for every hour for the hourly refreshes. At least, that is how I have for all my Excel Online, SharePoint sources which then refreshes every hour.
12-05-2018 08:53 AM
From what I understand there is no need to set (manually set refreshes) if the file (Excel file) is in Sharepoint/OneDrive it should update around an hour after the last saved timestamp.
I always have the option though to manually set, but it does say automatic so it's kind of redundant if I manually set the time refreshes.
12-05-2018 09:05 AM
Hmm I thought the automatic refresh was for files (PBIX files stored in OneDrive or SharePoint) and not for datasets like Excel or SharePoint list. Will have to read on this and the article you provided to reconfirm.
12-05-2018 09:12 AM - edited 12-05-2018 09:14 AM
I checked for one of the WorkSpace that I have sourced straight from OneDrive and I believe the automatic refresh like I mentioned applies only for pbix files stored in OneDrive. Below are screenshots for one report with only a SQL datasource which does not have a refresh schedule set even yet the OneDrive schedule ran on its own:
12-05-2018 09:24 AM
Based on the reports that I have created containing only an Excel Online or SharePoint List as the source, I have had to set the scheduled refresh for every hour which caps at 8 times a day if you are a PRO user. The screenshot I shared earlier was from the Workspace that I created for all DEV work for the team and during the migration from another Workspace moved all reports to the DEV-Workspace's respective One-Drive Folder which gets created when one creates a WorkSpace in PBI. These OneDrive refreshes according to my use and knowledge only refresh the PBIX file if they are located in the Workspace's OneDrive. It