Forum Discussion
PowerBI Report Builder query parameters
Hi, gvinokur
Please check if below tutorials could help:
Add a multi-value parameter to a paginated report
All About Multi Value Parameters in Power BI Paginated Report | Tips and Tricks in Paginated Reports
PAGINATED REPORT (MULTI VALUE PARAMETER)
Best Regards,
Community Support Team _ Eason
Thank you for your suggestions. My problem however lies not in building report with multi-value parameter - I've done it as described in videos you linked. The problem is that when report is executing query on Oracle it passes to Oracle text string containing SQL statement. In that statement text parameters are listed with prefix N. Like I stated above: cust_id IN (N'31341234134kwer', N'3898798734asf'). That means parameter values have been given in national character set. Since cust_id is VARCHAR2 it's been converted to NVARCHAR2 before comparing with parameters values. That in turn is stopping Oracle from using index based on cust_id column and consequently causes performance problems.
I am looking for a way to let PowerBI Report Bulder pass text parameters without N at the beginning of parameter value. It's got to be some Report Builder's configuration settings or at least I hope so...