Hi!! I have a Power BI report calling a Stored Procedure in Oracle, the SQL script I run is:
DECLARE P_RC SYS_REFCURSOR; BEGIN commpied."COP_PRICE_VALIDATION_REPORTS_PKG"."COP_CXL_PRICE_VALIDATION"(null, null, P_RC); DBMS_SQL.RETURN_RESULT(P_RC); END;
While this SQL script runs OK and generates a result-set that can be displayed in Power BI Desktop, when we publish this report to Power BI service and mapping the report's Dataset with a Data Source on the Gateway, we get this error:
The '<pii>REPORT_TYPE</pii>' column does not exist in the rowset. Table: Query1
It seems to me like the Gateway is not able to "catch-up" the final result-set loaded on an Oracle cursor, so it cannot identify any column referenced in Power Query as part of the result when running the SP.
Has anyone seen this error before? Is there any known limitation about using Oracle Cursors in Power BI service via the Gateway?