Your Excel options may look something like this:Ĭlicking “Copy path” will give you a path in this format: Update May 2020: Since this post was originally published, the Excel team has made this option a little easier to find. There’s no visual indicator that this label is a menu button until you hover over it, but when you click on it, a menu appears with a “Copy path to clipboard” option. In the Excel ribbon, click on the File tab, and on the Info screen that appears click on the label under the file name. It always feels like this should work, that I should be able to paste this URL into the Get Data experience in Power Query, and if it’s been more than a few months since the last time I tried, I expect it to work. In Excel and in SharePoint, there is a “copy link” option, which will copy a link to the workbook so you can share it with others. The problem is referencing the XSLX file. What’s the problem? It’s not working with the data – Power Query makes this as painless as you’d expect. And every time I’m connecting from Power Query to an Excel workbook located in SharePoint Online or OneDrive for Business, I find myself exclaiming “it shouldn’t be this hard!” Despite this, it feels like I end up needing to analyze data in Excel at least once a month. Although Excel has many benefits, its limitations make it less than ideal for enterprise BI solutions. I try to avoid using Excel as a data source when I can. Update September 2020: This post gets so many hits every day I decided to make a video.