Forum Discussion
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 + saved date" and tab are also same name.
Please guide me hoe i can create this
Anonymous ,
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.
6 Replies
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
Anonymous ,
Create a list type of query parameter and create three params like
Occup\FY18 Occup\FY19 Occup\FY20When 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 ,
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.
