Forum Discussion
Using a column distinct value as Parameter query list in Directquery mode
My problem is as below: I have a query in direct query mode. A table named “OuterJoin” and four parameters used in SQL query. When manage the Parameters, I want use the column (AetherExp...
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?
Sorry, just recognized that I misread your request.
It seems that removing duplicates is not supported in direct query mode, so this will not work unfortunately.
Any chance that you can create a view in the SQL-server for it instead?