Forum Discussion

JatinV's avatar
JatinV
Frequent Visitor
1 year ago

Power BI Report Builder Parameter Error

I am using an ODBC connection and connection to a PostgreSQL dataset. I want to use parameter passing in the query, but I am getting this error: 

ERROR [42703] ERROR: column "reportparameter1" does not exist;Error while executing the query

 

Here are the screenshots of the steps I have followed.

 

I have taken a small employee dataset to test this.

1) Created 2 datasets in the report builder, one with the actual data and another with distinct employee names.

 

2) Create the parameter.

 

3) Add it inside the Parameter section in Dataset1 properties.

4) I run the report, select a filter, and view report, I get this error:

 

Please provide a solution.

 

Thank You

 

"parameter"
"power bi report builder"

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi,JatinV .I am glad to help you.
    According to my observations and tests, your writeup does not have any problems with SQL Server databases

    So I think the problem is most likely related to the database you are using, PostgreSQL.
    Could you please first check the SQL query locally in the data source
    by defining the variables and subsequently querying the data in SQL with the In keyword.
    How to pass multiple value for a postgres function in SSRS - Microsoft Q&A
    PostgreSQL: Search results

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Carson Jian,
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.