Hello all, appreciate any help you guys can provide with this. I've seen a lot of posts and solutions about PowerQuery sourcing data from tables in OneDrive and SharePoint but my issue is with PowerPivot sourcing from a shared OneDrive folder.
We have a number of files stored in a OneDrive folder with several users having access to those files. There's also a number of PowerPivots that source from those files/tables. The problem is that only the creator of the PowerPivot is able to refresh the PowerPivot tables while everyone else gets an error message.
Any thoughts on how to fix this so anybody can use/refresh the PowerPivots?

Thanks.