The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
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
this is not the solution for oracle XE
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.