Load data from SubFolders

[Amardeep100115]

Hi Super Users,

could you please guide me how can i create patameter and pull data into report?

i have subfolders in my data storage by fiscal year and every folder has report with "Filename + saved date" and tab are also same name.

Please guide me hoe i can create this 

Reference Video 

[v-yuta-msft]

@Amardeep100115 ,

Create a list type of query parameter and create three params like 

Occup\FY18
Occup\FY19
Occup\FY20

When you open folder connector, you can select the defined query parameters above, after import all excel files in one subfolder, you can combine them as in the video you post shows:

https://docs.microsoft.com/en-us/power-bi/desktop-combine-binaries

Community Support Team _ Jimmy Tao

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

[Amardeep100115]

i am not very expert to create this 

could you please help me with examples

[v-yuta-msft · Accepted solution]

@Amardeep100115 ,

Please follow the steps in the third-party blog below:

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

Community Support Team _ Jimmy Tao

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

[Amardeep100115]

Hi @v-yuta-msft 

Thank you

[amitchandak]

Refer:

https://insightsoftware.com/blog/power-bi-load-data-from-folder/

https://docs.microsoft.com/en-us/power-bi/desktop-combine-binaries

[Amardeep100115]

Hi @amitchandak 

Thanks for quick reply

but what i am looking for is not in shared two links, i know those ways but if you refer the video then you will understand what i want. 

By creating parameter i would like to create table like in video but looking for solution on subfolders files

Thanks again for understanding