Forum Discussion
Solved
Power BI Report Builder Parameter (Oracle data Source)
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 f...
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 :
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 :
Bless you kind sir, exactly what I needed.
