Now that you have the file path you can close the file and create a query in a new Excel workbook using the From Web connector in Power BI or Excel (shown below): Then in Excel go to the File tab > Info and click the ‘Copy Path’ button: The trick is to go to OneDrive or SharePoint online and open the file from there in the Desktop App: If you try to copy a file’s path from here it will reference the copy of the file on your hard drive, not the OneDrive/SharePoint file path. You can see mine here in the file explorer: If you’re like me, you’ll have your OneDrive files synced to your hard drive. 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 Decision Making Under Uncertainty Course.Excel for Customer Service Professionals.
0 kommentar(er)
