Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Auto Refresh workbooks

Hey I'm learning Power BI for some stuff for work, and I connected an excel file that is on our team's site to Power BI, and it shows up under "Workbooks"  but it never refreshes unless I do it manua...
Need Help
Tutorial Requests
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    Is there a data model in your excel?

    If there is not, OneDrive refresh won't be enable.

    If there is a data model, OneDrive refresh could be enable.

    You can check it by referring to below screenshots:

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

collinq's avatar
collinq
Super User
6 years ago

Hi Anonymous ,

 

You would have to publish the report to the Service and you can refresh on the service up to 8 times a day with the basic license.

 

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

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!