Query parameters with Power BI Report builder

ExploreringPowe — Thu, 26 Oct 2023 22:12:04 GMT

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.

Re: Query parameters with Power BI Report builder

d_gosbell — Fri, 27 Oct 2023 02:22:30 GMT

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.

topic Query parameters with Power BI Report builder in Report Server

Query parameters with Power BI Report builder

Re: Query parameters with Power BI Report builder