report builder connection oracle

[perritocaliente]

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

[Anonymous · Accepted solution]

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

[perritocaliente]

this is not the solution for oracle XE

[rohit1991]

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

[perritocaliente]

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.