Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Power BI Report Builder connect to Oracle database

Submitted by Anonymous on ‎12-26-2019 07:36 AM

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
See more ideas labeled with:
7 Comments (7 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎12-29-2019 06:15 PM

Hi @Anonymous, 

 

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

Anonymous
Not applicable
‎04-03-2020 02:55 PM

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

 

 

Sri_1234
Frequent Visitor
‎04-08-2020 07:51 PM

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

Thanks

andres777
Advocate III
Advocate III
‎06-08-2020 01:36 PM

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

Sri_1234
Frequent Visitor
‎06-08-2020 02:34 PM

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

 

andres777
Advocate III
Advocate III
‎06-08-2020 02:59 PM

Which dll's need to be registered ?

Sri_1234
Frequent Visitor
‎06-08-2020 06:53 PM

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

 

Thanks

Idea Statuses