Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
@Anonymous,
As far as I know, there is no more elegant way.
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
110 | |
104 | |
84 | |
65 | |
63 |