Unable to render paginated report

[Anonymous]

We are using Oracle 12.2.0.1.0 

The stored procedure works when I run the paginated report on my local machine.  Once we publish it to the Power BI Report server and run the report it gives the below error.  I do have some date fields and I changed those to character fields and still it is not working.  

Here is the error

Data for this report could not be loaded due to an on-premises gateway error. A query in this report may be returning a field which is not supported by the on-premises gateway. Please remove any fields containing user-defined types or unsupported gateway types and try again.

[bradsy]

Hi PYHunter,

Want to double check, you are using Power BI Report Server and not the Power BI Service? Working with Oracle Sprocs have special behavior. Take a look at this article, it might help you. https://www.joellipman.com/articles/microsoft/ssrs/returning-oracle-stored-procedure-resultset-in-ss...