Using Oracle Cursors in Power BI service

[Anonymous]

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?

Thanks for your help!

[v-luwang-msft]

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 Regards

Lucien

[aj1973]

Hi @Anonymous 

Have you tried to update the Gateway?

[Anonymous]

Hello @aj1973 

Yes, and the error is still there...

Have you used Oracle cursors before from Power BI reports?

Thanks...

[aj1973]

No to be honest, but I have seen the message before and it was the update of the Gateway that solved it.