Data source

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.