Power Query: Make it easier to connect to files on OneDrive and SharePoint

[whopkins2]

Connecting to 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.

[nishalit]

Update 8/15/2024: Moved from Power BI ideas to Data Factory ideas.