Query paramater Automation

[lherbert501]

Hi ,

Does anybody know if its possible to have a list that opens off of a parameter like below to come from a sql query?

At present this is a manual list which then the template has to be manually amended everytime there is an addition.

Thanks

[AlexisOlson · Accepted solution]

Yes, it should be possible.

See the documentation here:
https://learn.microsoft.com/en-us/power-query/power-query-query-parameters

[lherbert501]

I dont know how I've missed that! 🤔

Thanks @AlexisOlson