We have many Excel files on SharePoint Online Document Libraries - well structured and maintained and refreshed. It would be great to be able to point to those directly. The OneDrive for Business i...
Maybe I'm misunderstanding the problem, but we do this all the time. In the query editor, for the source point to the path of your Excel file in SPO: Source = Excel.Workbook(Web.Contents("https://yourcompany.sharepoint.com/dashboards/Shared%20Documents/powerBI%20datafiles/powerBI%20datafile.xlsx"), null, true), That works every time. To get the document URL, get a link to the containing folder and then append the file name to that (spaces need to be replaced by “%20”). Let me know if that solves your problem.
