cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MalayJain Frequent Visitor
Frequent Visitor

Parameters in Power BI Report Builder not working with Power BI service

Hi,

 

I have some paramaters in a report developed in Power BI Report Builder.

Data source is Oracle 12c.

Report works fine from Power BI Report Builder client tool.

But after publishing to Power BI service, it's giving error and behaviour is unpredictable.

Sometimes it works with 2 parameter but does not work with 3 or more parameters.

It's giving following error:

Please assist.

 

Unable to render paginated report
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.
Activity ID: 51b33ec8-c6f1-1959-35af-3443dc80d0f4
Request ID: 51b33ec8-c6f1-1959-35af-3443dc80d0f4
Correlation ID: 267f27142740435a8126c3dd6176201c
Status code: 200
Time: Fri Jul 12 2019 15:53:14 GMT+0530 (India Standard Time)
Cluster URI: https://northcentralus.pbidedicated.windows.net/webapi/capacities/90A81C8A-ECFF-4400-947F-48AEDFD7AA...

 

 

2 REPLIES 2
bradsy Member
Member

Re: Parameters in Power BI Report Builder not working with Power BI service

Hi MalayJain,

 

Paginated RB will not go through the gateway, but directly to the Oracle Server. The service, goes the the Gateway. From the error description, not all data types and fields are supported by the gateway. I am not sure what is documented, maybe this article will help:

https://www.fourmoo.com/2017/04/26/power-bi-on-premise-gateway-configuration-steps-to-an-oracle-data...

Kareddy Frequent Visitor
Frequent Visitor

Re: Parameters in Power BI Report Builder not working with Power BI service

Any update on this issue. We are seeing the same issue for all paginated reports on PowerBI service.

 

Source : Oracle 12

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 391 members 4,145 guests
Please welcome our newest community members: