Skip to main content

Power BI

New

Load all files in a given OneDrive for Business Folder

Vote (35) Share
Brent Pearce's profile image

Brent Pearce on 17 May 2016 23:56:59

Currently via Power BI Desktop I can load all Excel or CSV files found in a given folder (either local or a server share). Need this same functionality for OneDrive for Business. Currently I can load via Get Data from Web one specific Excel file that sits in OneDrive, but unable to load all the Excel files that exist in the OneDrive folder. This function would allow Auto-Refresh of my source files without the need for a Gateway.

Comments (3)
Brent Pearce's profile image Profile Picture

25d3173a 91ce-4383-b59c-f69080415d12 on 16 Aug 2020 03:57:51

RE: Load all files in a given OneDrive for Business Folder

surprise to find this is not operational yet... this should have been a no-brainer requirement

Brent Pearce's profile image Profile Picture

64a11953 76b6-4b56-b4b5-cedffcb709db on 16 Aug 2020 03:55:04

RE: Load all files in a given OneDrive for Business Folder

This needs to be available for the online service also and not just desktop.

Brent Pearce's profile image Profile Picture

b40fc76b 9eca-4ea0-89a9-95c920fd6526 on 16 Aug 2020 03:54:36

RE: Load all files in a given OneDrive for Business Folder

This is really needed please provide this feature