Forum Discussion

ExploreringPowe's avatar
ExploreringPowe
New Member
2 years ago

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

  • 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.