Report Refresh Failing Due to online Dataset Changes

[Anonymous]

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

[Anonymous]

Hi, @Anonymous 

You can try connect excel in SharePoint by using SharePoint folder option in PBI Desktop. After testing, it works fine whatever the data is changed. You need to use personal gateway to get credential to configure schedual refresh in Service.

Power Query SharePoint folder connector - Power Query | Microsoft Learn

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum