- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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'm not finding an answer for this.
Thanks.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How is that a "Solved!" one?!?!
When it says "Currently is not supported. Please vote."
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That's a bummer. I'll definately be voting that one up.
What if I use Azure Blob storage or something like that?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Click the + next to datasets and select files (for onedrive). For dropbox you could Install the gateway and access it from your PC.
* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Subject | Author | Posted | |
---|---|---|---|
10-02-2024 01:19 PM | |||
Anonymous
| 12-29-2022 10:46 PM | ||
03-27-2024 06:59 AM | |||
10-07-2024 06:22 AM | |||
09-08-2024 05:30 AM |
User | Count |
---|---|
21 | |
16 | |
11 | |
10 | |
9 |
User | Count |
---|---|
35 | |
28 | |
18 | |
17 | |
13 |