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.
I have a report that I am attempting to have call a stored procedure inside of an Oracle database. In order to make this as simple as possible to debug, my SP is simply:
create or replace PROCEDURE test_proc IS varOne VARCHAR2(20) := 'hello'; varTwo VARCHAR2(20) := 'world'; BEGIN DBMS_OUTPUT.PUT_LINE( varOne|| ' ' || varTwo); END test_proc;
Inside of Power BI, I connect to the database server and give the following SQL statement:
BEGIN test_proc(); END;
The SP works fine when called from anywhere else. When called from Power BI, the first error I recive says:
Details: "EvaluateNativeQueryUnpermitted failure: the query 'BEGIN
test_proc();
END;' isn't approved for execution."
I then hit "retry" on the dialog box that contains that error, it then brings the popup to ask if I want to allow the native database query. I hit "Run" and then I get an error that says:
Details: "This native database query isn't currently supported."
So, are stored procedure calls to Oracle databases not supported?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.