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 spreadsheet onedrive could power BI refresh this when i am offline. 

 

sorry i have limited knnowledge of this.

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.

4 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    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
     
    • 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.

  • NewbieJono's avatar
    NewbieJono
    Post Partisan
    5 years ago

    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?