Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 (AetherExperimentId_T1”)’s distinct value as parameter (AetherExpId_A) ‘s value list.
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.
But when Save it, the error info is as below.
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!
Please check this method: https://community.powerbi.com/t5/Desktop/Parameterized-SQL-Query-with-query-folding/td-p/171503
You will only be able to reference non-SQL items as text for this to work.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
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?
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |