Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Load data from SubFolders

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 ...
Need Help
Show and Tell
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

Anonymous ,

 

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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    i am not very expert to create this 

    could you please help me with examples

     

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi v-yuta-msft 

         

        Thank you