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...
Albert1835
Copper Contributor
Brett Kraiger I had the same problem and nothing seemed to work (extra permissions, etc).
The problem occurred after changing the filename and although the name in de source path was exactly the name of the file (same capitals letters), it didn't work anymore.
At last I removed all capital letters in the filename and also removed the capital letters in de source path in Power Query. Suddenly the file was accessible again.
MrWLJ71
Sep 20, 2023Copper Contributor
Thank you for taking the time to post. I removed capital letters and it worked for me also, mad!
I only had to change the filename caps to lower case and 'browsed' to the source file and it all worked.
Thank you!
- Katri1250Oct 25, 2023Copper ContributorFYI, I had the same issue in OCT2023. Filenames with spaces, dashes, and underscores open just fine. Adding capitals screws them up, and converting to lc restores the ability to load.
Thanks for this thread - you helped me solve my problem quickly!