Forum Discussion
Problems with refreshing dataset
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!
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
5 Replies
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
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?
