Power BI Report Builder connect to Oracle database

Hi Anonymous, 

1. In Power BI report builder, create a data source which uses Oracle data source connector. 

2. Create a dataset based on the data source created in above step, you can write query to retrieve data. 

3. To create parameters follow this document: https://docs.microsoft.com/en-us/power-bi/report-builder-parameters

Best Regards,
Qiuyun Yu

Hi @Qiuyun yu

Thanks for helping me connect Power BI report Builder with Oracle. Now i am facing different issue. 

I have created report in power bi report builder using Oracle datasource and published to power bi service. The workspace where i published the report has premium capacity; datasource and gateway connections are correctly mentioned however it is giving the error : DM_GWPipeline_Gateway_ProviderDataAccessArgumentError in Power BI service

Error details:- 

An  unexpected error occurred
A data source used by this report returned an error. If you continue to experience this error contact the report author or data source owner quoting: DM_GWPipeline_Gateway_ProviderDataAccessArgumentError
Activity ID: f0eca880-cf1a-a9c7-ccbc-db49a9d537e3
Request ID: f0eca880-cf1a-a9c7-ccbc-db49a9d537e3
Correlation ID: bb432535884c4da4a0b60deae1b4d392
Status code: 200
Time: Fri Apr 03 2020 17:13:23 MT-0400 (Eastern Daylight Time)
Cluster URI: https://northcentralus.pbidedicated.windows.net/webapi/capacities/8402C0C6-A9A2-4F0F-BA30-A738954251...

Please help

Thanks

I am having same issue in my environment.Did you get any solution for this?Please help.

Thanks

Same issue for me also : 

An unexpected error occurred
A data source used by this report returned an error.
If you continue to experience this error contact the report author or
data source owner quoting: DM_GWPipeline_Gateway_ProviderDataAccessArgumentError
Activity ID: 31e3b41f-41ff-50c9-cda7-bace3e5c32c9
Request ID: 31e3b41f-41ff-50c9-cda7-bace3e5c32c9
Correlation ID: 2c99581f40c14f3fa8ef27c894d740a6
Status code: 200
Time: Mon Jun 08 2020 14:50:08 GMT-0500 (Central Daylight Time)
Cluster URI: https://northcentralus.pbidedicated.windows.net/webapi/capacities/F3068F2C-A61E-45CC-AB7B-B66571036DF3/workloads/RsRdlEngine/rs/automatic/v1.0

Do we need to install only the ODAC 12.2c (I already did this),

or do we need to install ORACLE Client 32bit + 64bit on the Gateway server ?

Thanks

Hi andres777  , 

We opened Microsoft support ticket and Insatalled ODAC 12.2 (64bit)on gateway server and problem is resolved.They registered DLL and started working.

Thank you

Which dll's need to be registered ?

He ran few commands in the server itself it started working. I dont know those commands.

Thanks