Forum Discussion
Query Parameters in Paginated Report(Text Editor) against DB2 database
Hi All, We are using SQL Queries in Power BI Report builder for reports development aganist DB2 database. I am facing an issue to pass values using parameters in SQL Query. select distinct A...
Hi SowjanyaB
Did sevenhills 's method solve your problem? If yes, could you please mark it as solution? This will help more users who are facing the same or similar difficulties. Thank you!
If you still have questions, please feel free to ask me.
Best Regards,
Yulia Xu
I should pass only ? not ?EmployeeID. In this case, if i am going to use same parameter multiple times, it will be difficult to maintain the code. It is creating ambiguity when more than one parameter should be used multiple times.
Replacing @EmployeeID with ? worked for DB2 but it didnt suffice for the complete requirement.
JOIN(Parameters!pCategory.Value, “,”) is not working when multiple values are selected.