Parameters from Excel table

[Anonymous]

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

[Anonymous]

This article from Ken Puls should help you.

https://www.excelguru.ca/blog/2018/05/30/creating-dynamic-parameters-in-power-query/