Connect Sharepoint folder, then subfolder and then file

[12-pune]

Hi all,

I have a sharepoint location under which there is a DOCUMENTS section(which is on left).
In Documents, there are 2 folders named as ABC and XYZ.

Now under ABC folder we have sub-folder named as AB,BC and CD. In each sub folder we have csv files that we need to connect to Power BI.

Under XYZ folder we have sub folder names as XY,YZ. In each sub folder we have csv files that we need to connect to Power BI.

In future, we will havee more sub folders and more csv's under sub folders, so need to make it dynamic.

Please help us on this.
Below is the screenshot of hierarcy, which will clear more to help me.

[v-jianboli-msft]

Hi @12-pune ,

It seems like you want to change the data source dynamically?

You might consider using parameters to create dynamic datasets. Instead of opening the Power BI file and republishing it every time, you can change the source or use any other content from it.

For more details, please refer to:

Change the Source of Power BI Datasets Dynamically Using Power Query Parameters - RADACAD

Best Regards,

Jianbo Li

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