Either way the process is the same and it requires getting the file path, but not the file path as you know it. I’ll start with getting data from an individual file on OneDrive or SharePoint. Get Data from a Single File on OneDrive or SharePoint with Power Query Excel for Customer Service Professionals.
