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 have the same issue. I have several CSV files provided externally which are in different folders based on month with one file in each. I am trying to write a query to combine the month files but March is allowed but January isn't! (for example). Using the wizard I get the same refusal. I moved the files from iCloud to local to see if that helps (it doesn't). The File Info data is apparently identical. Not really sure what MS are doing here.
If it adds anything to the solution, I've just discovered that copying and moving the files achieves nothing but opening the CSV in Excel and Save As (a CSV somewhere else) fixes the access issue. I'll try deleting the originals and replacing them in the original locations with the Saved As files. Not a solution but it might inform the real solution
