[DataSource.Error] Access to the path '/Users/.............is denied

Hi Timi11 ,

When working with Power Query, it’s essential to use relative paths to ensure portability across different systems and locations.
You mentioned that the second file connects to the first one via Power Query. To make this work seamlessly across platforms, consider using relative paths instead of absolute file paths.

And ensure that your OneDrive is fully synced and that you don't have any pending uploads or downloads. Sometimes, incomplete syncs can cause access issues. Ensure that the OneDrive sync app for MacOS is up to date. Microsoft frequently updates these apps for performance and security improvements. You can find instructions for setting up and troubleshooting the OneDrive sync app on MacOS here.

Since the issue doesn't occur when OneDrive is turned off, it's possible that the local OneDrive folder on MacOS has incorrect permissions. You can try to manually set the permissions for the OneDrive folder to ensure that Excel has the necessary access.

In addition, if you want to use Power Query on macOS, it is generally recommended that you use Excel for Mac. it is possible that the data source you created on your Windows system may have caused a cross-platform compatibility error, so you can try to create the same data source again on macOS and put it into OneDrive to see if there is a problem! You can try to create the same data source again in MacOS system and put it on OneDrive to see if there is any problem.
Import and shape data in Excel for Mac (Power Query) - Microsoft Support

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.