Forum Discussion
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
- Dinesh_SurangaContinued Contributor
Anonymous ,
Do you get any error messages?
Thanks
- AnonymousNot applicable
I did not get any error messages
- Dinesh_SurangaContinued Contributor
Anonymous ,
Where do you have your data set?
in Power BI desktop or Power BI service?
Thank you