Schedules/On-demand refresh failed

haqv 

Incremental refresh with sharepoint or onedrive is not feasible though there are few workarounds, pelase follow the instructions in this video and see if there is anything wrong in the implementation 

https://www.youtube.com/watch?v=6Uy59RsqgrM

I would suggest you not to perform the full load during the initial refresh, rather perform the bootstraped refresh i.e. truncate the dataset and perform the first load. This will create empty partitions in the power bi service. Then refresh the partitions one after the other. Instructions are here

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla#prevent-timeouts-on-initial-full-refresh

Considering you are using data gateway, and your sources are excel files, make sure your gateway server has sufficient resources to perform the data refresh.

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!