Forum Discussion

SHDJason's avatar
SHDJason
Advocate II
9 years ago
Solved

Connect to folder?

Is there any way to get data from a folder (read all files in a folder like in desktop) using Power BI online. Reading from any online file directory--onedrive, onedrive for biz, dropbox, anything? I...
Need Help
Tips and Tricks
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    SHDJason

     

    Through Power BI Service, we can only select one file in the OneDrive folder. Selecting a folder which contains multiple files in OneDrive at the same time is not supported now.

    You can vote this idea here to push this function supported in the future.

     

    Best Regards,

    Herbert

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

SHDJason

 

Through Power BI Service, we can only select one file in the OneDrive folder. Selecting a folder which contains multiple files in OneDrive at the same time is not supported now.

You can vote this idea here to push this function supported in the future.

 

Best Regards,

Herbert

KevinKlar's avatar
KevinKlar
New Member
3 years ago

There is a workaround.  Goto file explorer.  Drill down to the folder that contains the files you want to load.    Do not select a single file.  Click in the addess window to highlight the file path.  Then copy the file path into the folder path box in Power BI.  It will commence the process of loading all the files in that folder into the query editor and combine them.  You cannot drill down and select individual files.  This seems to address the problem highlighted by others.  I find it curious that Microsoft limited the function of loading multiple files from folders in this manner.