![]() 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.
0 Comments
Leave a Reply. |