cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI Report Builder connect to Oracle database

Could anyone please help in providing the step by step guide to connect Oracle data source through Power BI report builder. I have requirement to get the data from database table and build the report using input parameters then publish it to Power BI Service. When user will enter the input parameters the report will display that data directly from database table. Appreciate any help.

Status: New
Comments
Community Support

Hi @ka207

 

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

q3.PNG

 

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

q4.PNG

 

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

 

Best Regards,
Qiuyun Yu

Regular Visitor

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:- 

Snap4.png

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

 

 

Frequent Visitor

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

Thanks

Advocate I

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-B66571036D...

 

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

Frequent Visitor

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

 

Advocate I

Which dll's need to be registered ?

Frequent Visitor

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

 

Thanks