Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 manually. I've been reading and seems workbooks done this way should be auto-refreshing hourly but its not. Am I missing something or does that feature require a Power BI Pro license? Thanks!
Solved! Go to Solution.
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.
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.
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
Proud to be a Datanaut!
Private message me for consulting or training needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.