Forum Discussion
Unable to render paginated report
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.
1 Reply
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-ssrs.html
