Connecting to a folder using dataflows

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

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.

Dears, Anonymous 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