Unable to render paginated report

Anonymous — Thu, 04 Nov 2021 12:49:58 GMT

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.

Re: Unable to render paginated report

bradsy — Thu, 04 Nov 2021 16:59:09 GMT

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

topic Re: Unable to render paginated report in Report Server

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.

Re: Unable to render paginated report