cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

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 

 

Annotation 2020-04-06 162951.jpg

 

 

Reference Video 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Load data from SubFolders

@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.

View solution in original post

6 REPLIES 6
Highlighted
Super User IV
Super User IV

Re: Load data from SubFolders

Refer:

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

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
My Recent Blog -Week is not so Weak Connect on Linkedin

Proud to be a Super User!

Highlighted
Post Prodigy
Post Prodigy

Re: Load data from SubFolders

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

Highlighted
Community Support
Community Support

Re: Load data from SubFolders

@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.

 

Highlighted
Post Prodigy
Post Prodigy

Re: Load data from SubFolders

i am not very expert to create this 

could you please help me with examples

 

Highlighted
Community Support
Community Support

Re: Load data from SubFolders

@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.

View solution in original post

Highlighted
Post Prodigy
Post Prodigy

Re: Load data from SubFolders

Hi @v-yuta-msft 

 

Thank you

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors