Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Data refresh not automating

I have a data set connected to an excel file in one drive. The excel file is living and constantly having new data updating which is refelecting in the one drive file. On power bi, I have the setting on to automatically refresh every hour if its connected to a one drive file, but it will not automatically refresh. I know the file is working because when I manually refresh in power bi, the data updates, but I need it to constantly updated throughout the day in power bi. 

  • Anonymous 

    Hi,

    I recommend you to load data using Sharepoint folder option.

    but you should have power bi desktop to do that.

    thanks

15 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      I did not get any error messages

      • Dinesh_Suranga's avatar
        Dinesh_Suranga
        Continued Contributor

        Anonymous ,

        Where do you have your data set?

        in Power BI desktop or Power BI service?

        Thank you