User Profile
adunn3
New Member
Joined 1 year ago
User Widgets
Contributions
Re: SharePoint Online Document Library
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.458Views0likes0Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.