topic Power BI Report Builder Parameter (Oracle data Source) in Report Server

Power BI Report Builder Parameter (Oracle data Source)

oj606481 — Thu, 06 May 2021 20:37:42 GMT

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.

Re: Power BI Report Builder Parameter (Oracle data Source)

AbhiSSRS — Fri, 07 May 2021 09:30:04 GMT

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-for-the.html

Re: Power BI Report Builder Parameter (Oracle data Source)

oj606481 — Fri, 07 May 2021 14:46:42 GMT

Bless you kind sir, exactly what I needed.