Oracle Stored Proc using Power BI Parms

[llarkin11]

I would like to use Power BI Parm with an Oracle Stored Procedure, but I am not sure how to define the Parm.

what is the code to declare the parm?

[llarkin11 · Accepted solution]

Code and Solution

Initial edit for Oracle call to stored procedure

DECLARE P_RC SYS_REFCURSOR;
P_YEARS NUMBER :=1;

BEGIN
ZSEL_DIM_FMS_FISCALYEAR (P_YEARS,P_RC);
DBMS_SQL.RETURN_RESULT(P_RC);
END;

Advanced Editor Prior to edit for YearsParm
let
#"Fiscal Year" = Oracle.Database("bgdwdev", [HierarchicalNavigation=true,
Query="DECLARE P_RC SYS_REFCURSOR;
#(lf)P_YEARS NUMBER :=1;#(lf)
#(lf)BEGIN#(lf)ZSEL_DIM_FMS_FISCALYEAR (P_YEARS,P_RC);
#(lf)DBMS_SQL.RETURN_RESULT(P_RC);#(lf)END;", CreateNavigationProperties=false])
in
#"Fiscal Year"

Advanced Editor After edit for YearsParm
let
#"Fiscal Year" = Oracle.Database("bgdwdev", [HierarchicalNavigation=true,
Query="DECLARE #(lf)P_RC SYS_REFCURSOR;
#(lf)P_YEARS NUMBER := "& Text.From(YearsParm) &";#(lf)
#(lf)BEGIN#(lf)ZSEL_DIM_FMS_FISCALYEAR (P_YEARS,P_RC);
#(lf)DBMS_SQL.RETURN_RESULT(P_RC);#(lf)END;", CreateNavigationProperties=false])
in
#"Fiscal Year"

[v-kelly-msft]

Hi  @llarkin11 ,

Thanks for sharing.

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

[llarkin11]

I was able to resolve, no help needed.

[llarkin11]

All sorts of examples for Microsoft platforms!

[v-kelly-msft]

Hi  @llarkin11 ,

Could you pls click  "accept as Solution" to close it?

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!