cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chuy-varela
Frequent Visitor

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;
 
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 4
v-luwang-msft
Community Support
Community Support

Hi @chuy-varela ,

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
Community Champion
Community Champion

Hi @chuy-varela 

Have you tried to update the Gateway?

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Hello @aj1973 

 

Yes, and the error is still there...

 

Have you used Oracle cursors before from Power BI reports?

 

Thanks...

aj1973
Community Champion
Community Champion

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

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!