Power BI Report Builder Parameter (Oracle data Source)

[oj606481]

Greetings,

I am new to paginated reports and am trying to add parameters to my existing dataset in Report Builder. The dataset is populated via an Oracle DataSource, and I have not been able to figure out how to utilize parameters with this Data Source. Is it even possible?

Any help would be appreciated.

[AbhiSSRS · Accepted solution]

The Paginated report datasets work the same way as SSRS datasets and you may easily add paramters to your report .

eg:

SELECT COl1, Col2
FROM Table1
WHERE Col3= :param1

SQLServer uses an @ for the parameters and Oracle uses a : (colon sign) for parameters.

you may refer to below for more details :

https://docs.microsoft.com/en-us/answers/questions/188686/how-to-pass-multi-value-parameters-in-ssrs...

[oj606481]

Bless you kind sir, exactly what I needed.