Forum Discussion
Power Bi Report Builder(Paginated Report)
Hi All,
I am trying to create a report in Power BI Report builder whose data set is a output of a procedure.
The DB is Oracle. I need to use the output of a stored procedure as my data set.
The procedure in the db is delined something like below
procedure <pr_name>(input_value in varchar2, pout out sys_refcursor)
I am able to run the procedure in the db using the below code
variable out_ref_cursor refcursor;
execute <pr_name>('input_value', :out_ref_cursor)
print out_ref_cursor;
However I am not sure how can I use the refcursor which contains the output of the procedure and create a dataset in the Power BI Report Builder.
Also to mention this <input_value> is also the parameter in the report builder.
So basically whatever I pass in the input_value of the procedure will be required to set as a parameter in the report builder and the output that is captured in the ref cursor will be the data set in the report builder...
Can any one please help me on this?
Thanks in advance
Ankhi
Hi Ankhi ,
follow these steps you may resolve this issue- Open Power BI Report Builder
- In Report Data panel, right-click Data Sources → Add Data Source
- choose connection type as oracle database and paste the connection string here. This will make a connection to oracle database.
- once the data source is created using this datasource create a dataset to fetch data from store procedure which is in oracle db
please gothrough with the below document and screenshot hope it may resolve your Issue:
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You.
Harshitha.
Community Support Team.
8 Replies
Not much has changed in this area when moved to the PBI Service, either of these might help you: https://learn.microsoft.com/en-us/power-bi/paginated-reports/report-data/oracle-connection-type or this: https://www.codeproject.com/Articles/857516/Creating-Report-using-Report-Builder-and-Oracle-2
Thanks for the reply bradsy.. Have gone through the 2nd link..however I am not able to find the option 'Use connection embedded in my report'. when trying to create a data source in the report builder I just have 3 options in the General section- Name , Connection Type and Connection String. The connection string build option is greyed out when I choose Oracle as Connection type.
I have followed the steps to install oracle client and set up env variables .. but not able to set up the connectivity via oracle now..
Any thoughts?
Thanks
Ankhi
Hi Ankhi ,
follow these steps you may resolve this issue- Open Power BI Report Builder
- In Report Data panel, right-click Data Sources → Add Data Source
- choose connection type as oracle database and paste the connection string here. This will make a connection to oracle database.
- once the data source is created using this datasource create a dataset to fetch data from store procedure which is in oracle db
please gothrough with the below document and screenshot hope it may resolve your Issue:
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You.
Harshitha.
Community Support Team.
Hi Ankhi,
Thank you for reaching out to the Microsoft fabric community forum.
I would also take a moment to thank bradsy , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the response has addressed your query, please Accept it as a solution so that other community members can find it easily.
Thank you
Harshitha.
Community Support Team.
Hi Ankhi,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please Accept it as a solution so that other community members can find it easily.
Regards,
Harshitha.Hi Ankhi,
May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.