Forum Discussion
Using Postgres as a data source and create mutli value selection in power builder
Hi gantwanc,
Can you please share some more detail information about this? They should help us clarify your scenario and test to troubleshoot.
How to Get Your Question Answered Quickly
In addition, I'd like to suggest you take a look the following document about add multi-value parameter in paginated report and the limitations:
Add a multi-value parameter to a paginated report - Power BI | Microsoft Learn
Regards,
Xiaoxin Sheng
- gantwanc2 years agoFrequent Visitor
Anonymous Hello, Please see more details below:
1. I am connecting to an ODBC connection type using an Amazon Redshift driver as a connection string2. Within the query I use a ? next to the where clause to be able to use the parameter. This was the only way I was able to get the parameters to work using a ODBC connection type. for SQL server I use @ and I am able to select multiple filters.
The query is select multiple fields from table where market in ? (This is the parameter symbol)
3. The parameter properties are the same as the below screenshot:4. when I try to test the report I am trying to select multiple years or markets. The below case is the markets:
5. When I run the view I get the below error message:
What is the best way to allow multiple selections using a ODBC connection?
- gantwanc2 years agoFrequent Visitor
Anonymous The documentation seems to be geared towards SQL Server. I was wondering how to do the same thing connecting to ODBC. Is there any documentation that shows how to connect to other databases besides SQL Server?
- gantwanc2 years agoFrequent Visitor
Anonymous Here is another screenshot:
- Anonymous2 years agoNot applicable
HI gantwanc,
How did you define the parameter and query string? Can you please share some more detail?
BTW, you can also take a look at the following link about the similar issues:
Xiaoxin Sheng