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

[v-zhouwen-msft · 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.

• Troubleshoot if needed:

  • Check permissions on the stored procedure.
  • Use schema name if necessary (e.g., schema.procedure_name).
  • Click Validate Query to test the connection.
    Hope this helps ! 🙂
    
    

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