Forum Discussion
report builder connection oracle
hi, is it possible to connect my oracle Express Database with power bi report builder and get the stored procedures that i've created? i say this because i cant found it and dont know how to get to the solution. i send a screeenshot
Hi rohit1991, thanks for the quick reply, I'll add more.
Hi perritocaliente ,
Try clicking on 'Query Designer', my data source is Sql server and it shows stored procedures for the corresponding database.
Best Regards,
Wenbin Zhou
4 Replies
Hi,
Install ODP.NET by downloading Oracle Data Access Components (ODAC) from the Oracle website.
In Power BI Report Builder, go to Data Sources > New. Select Oracle as the type. Use a connection string, e.g., Data Source=localhost/XEPDB1; User Id=your_username; Password=your_password;.
In Datasets, right-click > Add Dataset.Choose your Oracle data source. Set Query Type to Stored Procedure and enter the procedure name
Hi my friend, unfortunately i can't see my stored procedures in the dropdown. i can use it by calling them all but i cant see them.
Hi rohit1991, thanks for the quick reply, I'll add more.
Hi perritocaliente ,
Try clicking on 'Query Designer', my data source is Sql server and it shows stored procedures for the corresponding database.
Best Regards,
Wenbin Zhouthis is not the solution for oracle XE
