Query parameters with Power BI Report builder
Hi All, I am new to Power BI report builder and getting an issue while using parameter in the query . Datasource - Connection to Redshift ParameterName cust1 Text Query select * from table1 where cust =@cust In Parameters Cust = Cust1 Query validated successfully. While running a report error is: ERROR [XX000] [Amazon][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState XX000] ERROR: Overflow for NUMERIC(18,0) DETAIL: ----------------------------------------------- error: Overflow for NUMERIC(18,0) code: 1207 context: Value: '30892661097793872890', Character: '9' query: 40025589 location: :0 process: query0_223_40025274 [pid=0] ----------------------------------------------- ---------------------------- Query execution failed for dataset 'DataSet1'. ---------------------------- An error has occurred during report processing. ---------------------------- An error occurred during local report processing.
