Best practice of using Parameters

[Anonymous]

Hello friends,

I frequently build queries that get user input such as Date, FilePath, Customer Number, etc.

Currently - I allow my users to enter the parameters into an Excel table and FOR EACH parameter I build a query that ends with converting the Parameter to a List (with one value). Then, I use itas a parameter where I need it. What bothers me - is that I have a separate Query for each parameter (though all of them reference one Query that imports the Excel file).

What is the best practice for this case? How would you recommend importing and using several Parameters?

Thank you

Michael

[v-chuncz-msft]

@Anonymous,

As far as I know, there is no more elegant way.