Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
perritocaliente
New Member

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 screeenshotCapture.PNG

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

vzhouwenmsft_0-1730255835931.png

vzhouwenmsft_1-1730256000207.png

 

Best Regards,
Wenbin Zhou

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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.

vzhouwenmsft_0-1730255835931.png

vzhouwenmsft_1-1730256000207.png

 

Best Regards,
Wenbin Zhou

this is not the solution for oracle XE

rohit1991
Super User
Super User

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



 


Did it work? ✔ Give a Kudo • Mark as Solution – help others too!

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. 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.