Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I need to call an Oracle Stored Procedure from Power BI report builder(Paginated Reports) . I have created the oracle data source sucessfully. I am able to run oracle sql queries as well but I am having issues calling oracle SP. Could any anyone please let me know the steps and possible provide an example?
Thanks,
Savita
Solved! Go to Solution.
Hi @savitaa ,
As far as I know, Oracle stored procedures cannot be called directly from the power Bi report builder.
You may try to connect stored procedures in desktop, publish them to service, and then connect to datasets using report builder.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @savitaa ,
As far as I know, Oracle stored procedures cannot be called directly from the power Bi report builder.
You may try to connect stored procedures in desktop, publish them to service, and then connect to datasets using report builder.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thanks Liang for info !
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |