Problems with refreshing dataset

[majoh3]

Hello

Im kind of new to PowerBI and have run into a problem with refreshing one of my datasets.

We have several reporots collecting data through our gateway server that i have set up. And they are working fine with scheduled refresh. But yesterday i designed a new report based on a dataset based on an excelfile stored in Sharepoint online, where users input production data each morning. I can chose "schedule a refresh" from the dataset. but once there it looks like this:

The dataset seemes to update itself every 4 hours or so, but i need to be able to schedule an update.

Any help would be much appriciated!

[majoh3]

Hi 

Thank you, i've found several topics saying  that the Onedrive refresh seemes to work somwhat strange. Not at all updating every hours. Seemes like i should perhaps use Power Automate to do a refresh instead?

[Pragati11]

HI @majoh3 ,

Yes you can try if this doesn't work for you.

Thanks,

Pragati

[majoh3]

@Pragati11 

If i look there: It's enabled, and i was guessing it's because of this that it updates every 4 hours. Do you know where i can change  the  settings? 

[Pragati11 · Accepted solution]

HI @majoh3 ,

As your datasource is a Sharepoint Online for your report, in such cases Power BI has a different refresh type which is One Drive Refresh and it refreshes data on hourly basis.

For more details check the documentation here: (Search for 

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

Thanks,

Pragati

[Pragati11]

HI @majoh3 ,

Under One Drive Refresh you should be able to set-up schedule refresh.

Thanks,

Pragati