Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
Hi,
I've created a report stored locally on my laptop which grabs excel data from a project folder on our company network.
This works very well.
Through Parameters I found a way to change the path where the excel data is grabbed from:
This was setup by adding Parameters and change the code below:
But now I want the Parameter list to get its input from a data source (Excel sheet), so that I can add/remove projects to the Excel table and then the projects will be added/removed in Parameters.
Is this possible?
Kristoffer
This article from Ken Puls should help you.
https://www.excelguru.ca/blog/2018/05/30/creating-dynamic-parameters-in-power-query/
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 8 | |
| 8 | |
| 7 |