Using a column distinct value as Parameter query list in Directquery mode

Question

My problem is as below:&nbsp;I have a query in direct query mode. A table named “OuterJoin” and four parameters used in SQL query.&nbsp;&nbsp;When manage the Parameters, I want use the column (AetherExperimentId_T1”)’s distinct value as parameter (AetherExpId_A) ‘s value list.&nbsp;&nbsp;&nbsp;&nbsp;What I did is generate a table to get the column distinct value and convert to List. Then I can choose this list query as parameter query above.&nbsp;&nbsp;But when Save it, the error info is as below.&nbsp;&nbsp;&nbsp;May I know is there a solution if I want to use the column distinct value as Parameter query list in Directquery mode?Great Thanks!&nbsp;&nbsp;&nbsp;

imkef · Answer

Please check this method: https://community.powerbi.com/t5/Desktop/Parameterized-SQL-Query-with-query-folding/td-p/171503You will only be able to reference non-SQL items as text for this to work.

nicolet · Answer

Thanks ImkeF! I appriciate it! But I need offer user the parameter value list to choose when they open the power BI template since the data is very big. Any suggestion?&nbsp;