Anonymous's avatar
Anonymous
Not applicable
6 years ago
Status:
New

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...
Reports
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

 

 

Completed Ideas