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
Query Parameters for Teradata SQL Query in Report Builder
I am trying to use query parameters in a query to Teradata. When I use the (@ParameterName) syntax, I get a Teradata error saying the number of parameters called does not match the number of parameters defined. My assumption is that the call for parameters in Teradata is the same as Report Builder, so Teradata is getting confused? I also tried the M Query parameter call "&ParameterName" and it actually called the value. But I got an error saying Teradata expected something between a unicode value and the parameter. Is there a way to escape the parameter call? Or there some other syntax I can use?
