Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
i am not very expert to create this
could you please help me with examples
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.
Refer:
https://insightsoftware.com/blog/power-bi-load-data-from-folder/
https://docs.microsoft.com/en-us/power-bi/desktop-combine-binaries
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |