Forum Discussion
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.
1 Reply
- d_gosbellSuper User
That is a Redshift error not specific to paginated reports. Probably caused by trying to pass 20 digit number to filter a number(18,0). You cannot filter an 18 digit column with a 20 digit value.