Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
5 years ago
Solved

Refresh Data from excel workbook

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 spreads...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    5 years ago

    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.

NewbieJono's avatar
NewbieJono
Post Partisan
5 years ago

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's avatar
v-yalanwu-msft
Community Support
5 years ago

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.