Forum Discussion
Resolver IOracle Stored Proc in PBI Desktop
For anyone in the same boat as me - Oracle stored proc with ref cursors can be executed within power bi desktop. It just need to be run with cursor variable declaration.
Resolver IYes, it worked for me over gateway. There is no reason why it will work in power bi desktop but not via gateway. Execute the stored proc using gateway datasource account credentials to see if there are any permission issues
thank you for the response Rakesh. As another poster, Chuy, responded with (we work in the same organization and he is assisting me with trying to troubleshoot the error). The report and SP executes using the gateway credentials. But we get the error below when refreshing the data set after the report has been published to Power BI Service using the gateway:
The error message we get in Power BI service is:
The '<pii>Column Name</pii>' column does not exist in the rowset. Table: Query1
I have also read that some versions of Oracle client do not support sys_refcursors -- could this be the issue for our Gateway server? Is there any other Gateway server configuration that needs to be enabled? This report runs and refreshes without error in Power BI Desktop on multiple machines.