Power Query: Make it easier to connect to files on OneDrive and SharePoint
Connecting to Excel files stored on OneDrive and SharePoint is a difficult and confusing experience. While it is possible, it is far too difficult.
As more and more move to working in an online environment we need a simple way of connecting.
Strangely, opening an Excel file on SharePoint for business is easy and works like charm. Just select the file in the explorer and it all happens. That should also be the experience within Power Query.
Jason Tan commented
It's indeed a huge pain point to figure out the right path to connect to OneDrive Personal/Business and SharePoint. MSFT really need to come out a seamless solution ASAP!