Forum Discussion
Need to load all Excel files in a given OneDrive folder...
Using Power BI Desktop, I can readily load to my data model all the Excel files in a given folder. Works great. However, I can't figure out how to accomplish the same if the files are in a OneDrive f...
Solved:
1. Get a list of files (URLs) via = SharePoint.Tables("https://SomeOrgName.sharepoint.com/personal/Email_with_undescores/", [ApiVersion = 15])
2. Expand Documents "Table"
3. Expand "File.LinkingUrl" and split by "?" to get a clean URL
4. Do filter the desired folder (via URL or Folder.Name or other attribution)
5. Add a Custom Column = Excel.Workbook(Web.Contents([File.LinkingUrl))
Anton´s solution seems to work.
Does anyone know why this happens? Sometimes the Sharepoint.Folder connector works fine, is this a permissions issue? o something on the OneDrive config side?
Also, I need to combine files all the files that are in the folder. Can that be done using this method?