Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
metawops
New Member

Dataflow with OneDrive folder as source?

Hello folks,

I'm new to Power BI in the cloud (know the Desktop version for about a year now) and wanted to create a data flow with a folder as a source (which contains several CSV files). This folder is on my tenant's OneDrive. However, I think I understood that the "Folder" source for a data flow is only meant for an on premesis folder and has to be connected via a gateway, right?

 

So how would I then connect this OneDrive folder and it's CSV files to a data flow? Is this possible at all?

 

I tried my tenant's SharePoint, too, but to be honest: I don't want to have to create a website first to have a "Documents" folder where I put the raw CSV files. (I tried, though, but got errors.)

 

Thanks a lot in advance!

1 ACCEPTED SOLUTION
metawops
New Member

Ah! I found the solution here: https://www.youtube.com/watch?v=zoH_9L9sPYs

The key is to use the SharePoint Folder data source with the base URL of the OneDrive but then later manually change the "SharePoint.Files" to "SharePoint.Contents"! 😉

View solution in original post

5 REPLIES 5
StephenF
Responsive Resident
Responsive Resident

Bit much that two top tier MS products cant talk to each other.

I cant read a folder full of excel files from a dataflow either. Doesnt even give a proper error message, just wont accept a URL in the folder input method.

metawops
New Member

Ah! I found the solution here: https://www.youtube.com/watch?v=zoH_9L9sPYs

The key is to use the SharePoint Folder data source with the base URL of the OneDrive but then later manually change the "SharePoint.Files" to "SharePoint.Contents"! 😉

collinq
Super User
Super User

Hi @metawops ,

 

Do you mean OneDrive or OneDrive for Business.  If you mean For Business this link should help Use OneDrive for Business links in Power BI Desktop - Power BI | Microsoft Docs

If you are trying to get an Excel file from OneDrive, this link should help:  Get data from Excel workbook files - Power BI | Microsoft Docs

Or, this link here:

Solved: Reading a onedrive excel file - Microsoft Power BI Community

 

Once you know how to connect to the file, then you can do this in DataFlow and/or Gateway as needed.  But, if it is really OneDrive, you should not need a gateway at all.

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Hi Collin

 

and thanks for your answer, much appreciated! 

My question has nothing to do with the MS Power Bi *Desktop* version. There, I have no problem accessing multiple files in a folder.

Instead, I want to create a Dataflow (to my knowledge this term only exists with the Power Bi Service/Cloud version?!). And I want to acces not just one CSV (not Excel) file but many CSV files at once, hence the Folder data source option I'm after. 😉

I have a M365 E5 tenant (that came with my MS Developer account) and that comes with a OneDrive. So I guess it's the business OneDrive then?

This is how I tried it:

  • On app.powerbi.com in a newly created Workspace I chose New > Dataflow
  • In the next dialog I chose the leftmost button, "Add new tables"
  • In the list of data sources I chose "Folder"
  • In the "Folder path" textbox I paste the URL to the OneDrive folder

Result: Both dropdown listboxes, "Data gateway" and "Authentication kind" only contain "(none)", nothing else is selectable. From what I read I understood that a gateway is only needed when accessing on premises files, which is not the case here because everything is in the MS cloud on my tenant.

The "Next" button in the lower right corner of the web page stays inactive, is not clickable.

 

2022-02-08 (2)_LI.jpg

That's where I stand and I'm wondering how I can add a OneDrive folder as a data source for a Dataflow. 

 

Thanks,

Stefan.

@metawops  I'm trying to do the same thing. Did you ever find a solution?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors