Forum Discussion

SHDJason's avatar
SHDJason
Icon for Advocate II rankAdvocate 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

SHDJason's avatar
SHDJason
Icon for Advocate II rankAdvocate II
9 years ago

That's a bummer. I'll definately be voting that one up.

 

What if I use Azure Blob storage or something like that?

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

SHDJason

 

We can get data from Azure Blob storage from Power BI Desktop. If you have multiple files in a container. You can select the container as below.

As we can see, in every line we will see all the files in our repository, and at the first column we will click on the option Binary to open the file. You can take a look at this article for reference.

 

 

Best Regards,

Herbert