I'm unable to import the csv file used in this tutorial. The error message reads "DataFormat.Error: The supplied file path must be a valid absolute path."
Hi Alistair,
Sounds like you might have provided a path that's to your SharePoint/OneDrive file location? Or maybe the path isn't formatted correctly. Hard to say without seeing it.
Mynda
I have the same problem with 7.03 and 7.04 exercises. I keep my files on my OneDrive and the @CELL function pulls the file path off the cloud OneDrive instead of my C: drive. For example:
https://d.docs.live.net/a5249ee0b7d80b3e/Documents/ ... which apparently is not a valid absolute path.
Is there anyway to force it to the file path on my computer instead? Such as:
C:Usersmgb75OneDriveDocuments ...
If I move everything to a folder not on OneDrive it works just fine.
Hi Michael,
I use the OneDrive sync tool to also store a copy of my SharePoint/OneDrive files on my hard drive. It automatically syncs them with the online version and allows me to use a C: file path.
To locate this file path you can go to Explorer and locate the file on your C drive and then copy the path, or browse to it in the Power Query dialog when it asks for the file.
If this isn't an option for you, then you need to use the SharePoint connector as explained in lesson 2.09, or if you don't have OneDrive for Business, then you'll have to download the file to your hard drive manually and get it from there.
Mynda
