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...
I found it was a simple error for me. Basically my csv was labeled as "varient.csv" but the data source was "Varient.csv". Fixed the capitalization and it worked fine.
I've also previously found simply restarting the computer fixed the issue.
I've also previously found simply restarting the computer fixed the issue.
Good idea. I tried to eliminate any case or special characters "features" by renaming all lowercase and no spaces but to no avail.
- I wonder if it's linked to what files are open and when. Having just had the failure above I closed the "reading" file, changed the name of the "source" file by making the first character UC, opened and closed it in Excel then reopened the "reading" file. Read worked. I'll try to be a bit more structured to try to focus down to where the problem occurs
