Forum Discussion
Using Oracle Cursors in Power BI service
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;
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?
Thanks for your help!
4 Replies
Hi Anonymous
Have you tried to update the Gateway?
Hi Anonymous ，
You could refer to below link which has similar issue:
The 'HasUniqueRoleAssignments' column does not exist in the rowset.
The column does not exist in the rowset
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
