Report Refresh Failing Due to online Dataset Changes

Hi PowerBI Experts,

I had a small query regarding refresh schedule failing on my report and am hoping can resolve it with your help and inputs,

I have a report published to powerbi server which uses an excel dataset hosted over Sharepoint site. I have connected that dataset using web option in powerbi desktop.

The problem I am facing is since multiple users use that sharepoint excel sheet if any data is changed in it, my scheduled refresh is failing and it throws error such as column missing or data missing.

Although I am not using all data from that excel file and have my data transformed using transform data option in my report still my refresh is failing,

Is there any workaround for this ? As of now I am fixing the errors reported in message on refresh schedule to fix and enable hourly refresh again.

Thanks a lot for your help in advance, I really appreciate it

Regards

Khush