Forum Discussion
Solved
Data source
I keep getting this error message, even when I add the file from my own sharepoint site... any clues?
Got it, thanks!
Hi b-kopik ,
When you use SharePoint Folder, the first screen only shows metadata (file names, folder paths, dates). That’s expected. To load the actual file data:
Connect with SharePoint Folder using only the site root URL.In Power Query, filter the table by Folder Path and Name until only your file remains.Click the binary link in the Content column - this opens the real file (Excel, CSV, etc.).Pick the sheet/table (for Excel) or raw data (for CSV), then Close & Apply.This way, you’ll get the file contents instead of just the file path.
Thank you.
Got it, thanks!