Forum Discussion

perritocaliente's avatar
perritocaliente
New Member
1 year ago
Solved

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 t...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

rohit1991's avatar
rohit1991
Super User
1 year ago

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's avatar
perritocaliente
New Member
1 year ago

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.