Data refresh not automating

[Anonymous]

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. 

[Dinesh_Suranga]

@Anonymous ,

Do you get any error messages?

Thanks

[Anonymous]

I did not get any error messages

[Dinesh_Suranga]

@Anonymous ,

Where do you have your data set?

in Power BI desktop or Power BI service?

Thank you 

[Anonymous]

Power bi service 

[Dinesh_Suranga]

@Anonymous 

Hi,

Can you share your dataset refesh settings as follow?

Thank you.

[Anonymous]

how do i get to that visual from power bi online? Im not using power bi desktop 

[Dinesh_Suranga]

@Anonymous 

Hi,

Go to workspace which your data set located.

Then click three dots as follow.

Then click Settings then you can see Sheduel Refresh.

Thank you

[Anonymous]

that option is not showing up for me

[Dinesh_Suranga]

@Anonymous 

Click on Settings.

Then Click Sheduled refresh.

[Anonymous]

 still isnt appearing for me unfortunately 

[Dinesh_Suranga]

@Anonymous 

Can you see any data in Refresh history?

[Anonymous]

yes this under one drive and nothing under the scheduled tab

[Dinesh_Suranga]

@Anonymous 

Please watch following video and and configure your settings.

https://www.youtube.com/watch?v=ojFx23WQBCY

 Thank you

[Anonymous]

Im using a mac and am unable to download gateway. Is there any way i can solve this without gateway and with out using power bi desktop? 

[Dinesh_Suranga · Accepted solution]

@Anonymous 

Hi,

I recommend you to load data using Sharepoint folder option.

but you should have power bi desktop to do that.

thanks