DataSource Error Access To The Path is Denied / PowerQuery Mac

I've got the same issue and I've just spent a couple of hours with MS tech support but did not get a solution. My issue only occurs when trying to import from a network folder. Interestingly the first tech support agent got me to run the license removal tool and after doing that the issue was resolved in a test file. I then tried my project Excel file and initially the problem persisted, but I then browsed to the file again in the wizard and then it imported successfully. I then tried the same process on other datasources in the same excel file but it did not work.

I have also tried opening my excel file in the Windows version and setting privacy to none and also setting the ignore privacy flag in the file. None of those steps helped, when I open it on mac its still not working.