Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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 ?!
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
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.
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.
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
Happy to help!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
30 | |
28 | |
23 | |
21 | |
18 |
User | Count |
---|---|
55 | |
37 | |
28 | |
24 | |
21 |