Connect to files on OneDrive and Sharepoint
Connect to Excel files using Power Query Power Query can connect to Excel files held in OneDrive for business and in SharePoint. But it's not obvious how. Whether you use Excel or PowerBI this approach will work. Also, for a pure "M" code approach to SharePoint you can use something like this to get your data [...]