Reply
Established Member
Posts: 393
Registered: ‎01-18-2017

OneDrive Source | Automatic Refresh Question

Hi,

 

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?

 

OneDrive Auto Refresh.PNG

Community Support Team
Posts: 2,523
Registered: ‎02-06-2018

Re: OneDrive Source | Automatic Refresh Question

Hi ovetteabejuela,

 

Has the file in onedrive been updated? If the file is not updated in onedrive, power bi will not refresh the content automatically.

 

Regards,

Jimmy Tao

Established Member
Posts: 393
Registered: ‎01-18-2017

Re: OneDrive Source | Automatic Refresh Question

[ Edited ]

Hi Jimmy,

 

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.

Established Member
Posts: 267
Registered: ‎02-01-2018

Re: OneDrive Source | Automatic Refresh Question

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.

Established Member
Posts: 393
Registered: ‎01-18-2017

Re: OneDrive Source | Automatic Refresh Question

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. 

 

Reference: 

https://docs.microsoft.com/en-us/power-bi/refresh-data#local-files-and-files-on-onedrive-or-sharepoi...

Highlighted
Established Member
Posts: 267
Registered: ‎02-01-2018

Re: OneDrive Source | Automatic Refresh Question

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.

Established Member
Posts: 267
Registered: ‎02-01-2018

Re: OneDrive Source | Automatic Refresh Question

[ Edited ]

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: 

OneDrive.PNGOne Drive refresh running on its on for a report purely sourced from SQLRefresh.PNGNo schedule refresh on this report is set

Established Member
Posts: 393
Registered: ‎01-18-2017

Re: OneDrive Source | Automatic Refresh Question

Thanks for this, actually both PBIX file and the source files(Excel) are located on OneDrive. Hmmmmm....

Established Member
Posts: 267
Registered: ‎02-01-2018

Re: OneDrive Source | Automatic Refresh Question

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