Forum Discussion

Lynk_RM's avatar
Lynk_RM
Helper I
6 years ago
Solved

OneDrive Refresh Frequency?

Hello all, I have a fairly simple question as a Power BI novice.   I've attempted to read, and re-read this article: https://docs.microsoft.com/en-us/power-bi/refresh-desktop-file-onedrive. I'm mos...
  • nandukrishnavs's avatar
    6 years ago

    Lynk_RM 

     

    Basically the link explains about keeping the pbix files in OneDrive or  SharePoint Team site. Not about connecting Power BI Desktop with excel files in OneDrive.

    If you click Refresh Now button in dataset settings, it should bring all the row changes from your excel. (It may fail due to schema change or password expiration).

     

     

    Check out the below links

    https://docs.microsoft.com/en-us/power-bi/service-excel-workbook-files#where-your-workbook-file-is-saved-makes-a-difference

    https://docs.microsoft.com/en-us/power-bi/refresh-data#data-refresh



    Did I answer your question? Mark my post as a solution!
    Appreciate with a kudos
    🙂

  • v-kelly-msft's avatar
    6 years ago

    Hi Lynk_RM .

     

    Q1:Yes,it is loading all new changes which are made on the data source in Onedrive.

    Q2:Refresh means  datasets refresh which is  linked to the excel file,and the visualizations will be refreshed synchronously

    Q3:For onedrive,hourly is the only choice for refresh,if you wanna change the frequency,the best choice for you is to use a live connection way to connect with the data,such as  SQL,etc..Then you will see "schedule cache refresh",where you can choose 15min,30min...Otherwise,you can only choose  on-demand refresh ..

     

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!