Forum Discussion
DataSource Error Access To The Path is Denied / PowerQuery Mac
I am trying to read a datasource (CSV) into Power Query. I keep getting DataSource error saying that it cannot read the file. This happens whether I try using "Get Data" or just editing an existing...
No I got zero responses here, and none in other places I tried to seek out help, so I gave up and taught myself rudimentary R and got around the problem that way.
Brett Kraiger got the same issue, how did you solved it ?
MHLachaps the trick is to always use the wizard to open the json, do not rename or move the json file.
This is the only way I found. Probably the wizard automatically creates some permission on the file (not at the file system level, it is something within excel). In excel for mac there is no way to change these permissions once created by the wizardcaprinalim Thx, not a JSON but just a simple excel csv. I have tried it all (rename, change directory, delete and expert again, ...) for 1 of the 2 files it worked, not for the other one (same source though ...)
- I gave up and taught myself R instead
