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...
"Other than syncing your OneDrive folders locally..."
Sorry, I should have further specified it is critical that when published, Power BI must be able to refresh the data model. Thus specifying a local folder as a data source will not work.
Any other suggestions?
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))