Refresh Data from excel workbook

[NewbieJono]

i have a excel spreadsheet stored on my works SAN drive. i can set up a personal gateway for refresh but this means i have to have my computer on.

what options do i have. if i stored this spreadsheet onedrive could power BI refresh this when i am offline. 

sorry i have limited knnowledge of this.

[NewbieJono]

Thank you -  what is the diffrence for one drive for buisness? i have an account on my PC with my set personal space. can i use that?

[selimovd]

Hey @NewbieJono ,

yes, when you store it in OneDrive, Power BI can automatically refresh it, also when you're offline.

Check the following tutorial on how to import the file from OneDrive:

Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[NewbieJono]

i have connected my onedrive file to power BI, will i still need to schedule a refesh for the reports to update? or will they just update eveyr hour

[v-yalanwu-msft · Accepted solution]

Hi, @NewbieJono ;

Accoridng to the official document,
 By default, Power BI checks about every hour if a dataset connected to a file on OneDrive.As the above screenshot shows, Power BI identified this OneDrive refresh as a Scheduled refresh, but it is not possible to configure the refresh interval. You can only deactivate OneDrive refresh in the dataset's settings. Deactivating refresh is useful if you don't want your datasets and reports in Power BI to pick up any changes from the source files automatically.

and , you can still synchronize your dataset on-demand by selecting Refresh now in the dataset menu. 

so you don't need to schedule a refesh ,it will update every hour. in addition, you could use one drive for personal.

https://www.sherweb.com/blog/office-365/onedrive-business-vs-o365/

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.