Forum Discussion
Brett Kraiger
Jan 20, 2023Copper Contributor
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...
caprinalim
Apr 06, 2023Copper Contributor
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 wizard
MHLachaps
May 01, 2023Copper Contributor
caprinalim 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 ...)