Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
oj606481
Frequent Visitor

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 figure out how to utilize parameters with this Data Source. Is it even possible?

 

Any help would be appreciated.

1 ACCEPTED SOLUTION
AbhiSSRS
Solution Sage
Solution Sage

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

 

View solution in original post

2 REPLIES 2
AbhiSSRS
Solution Sage
Solution Sage

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

 

Bless you kind sir, exactly what I needed.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors