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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Khalidshurafa
Frequent Visitor

Connecting to a folder using dataflows

How can I connect to a folder data source using dataflow if I am using OneDrive Work account ?!

Is it a must to install a gateway or it can be done without ?!
If a gateway is a must, is it the one usually downloaded from the power BI service or a different one ?!


3 REPLIES 3
Khalidshurafa
Frequent Visitor

Dears, @v-kongfanf-msft @ibarrau 
Thanks for your replies
I actually had to change the dataset and had to make it all in one file as due to some organizatinal constrinats I wasnt able to connect to sharepoint nor install the data gateway

v-kongfanf-msft
Community Support
Community Support

Thanks for the reply from @ibarrau , please allow me to provide another insight:

 

Hi @Khalidshurafa ,

 

Whether a gateway is required depends on the location of the data source. Based on your description, for cloud services like OneDrive for Work or School, this is not required and the Power BI service can refresh the cloud service directly.


For dataflow connecting to folder data sources, you can use the Power query connector.

vkongfanfmsft_1-1717555080421.png

 

For more details, you can refer to below document:

Folder connector overview - Microsoft Fabric | Microsoft Learn

Set up your Folder connection - Microsoft Fabric | Microsoft Learn

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ibarrau
Super User
Super User

Hi. You can use the sharepoint folder connection with your Onedrive for business. Once connected you can change code and work with data in two ways. This post might help with conections for onedrive and power query:

https://blog.ladataweb.com.ar/post/627427136962281472/powerbi-obtener-datos-de-una-carpeta-de

I hope that helps


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

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.

Jan NL Carousel

Fabric Community Update - January 2025

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