there's no gateway to access the data source oracle

[hninhninshwe]

I have already done in gateway setting for oracle connection, it shows connection is good. But when I am trying to connect in reports, it shows as below

Couldn't retrieve the data for this visual. Please try again later.

Please try again later or contact support. If you contact support, please provide these details.

• Activity IDe1a6c8cc-e8ee-4a47-818b-77e06684a832
• Request ID252c4a77-a634-040e-356b-c68d76d79fe5
• Correlation ID43ccf298-97d8-496a-0276-04853f5e241e
• Cluster URIhttps://wabi-east-asia-a-primary-redirect.analysis.windows.net/

[lbendlin]

need more information.  What type of oracle connector did you create on the gateway? ODBC, SQL*Net, with or without TNS ?

You need to use exactly the same connector on the desktop as well.

[hninhninshwe]

I configured in TNS. I connected as below connection string at power bi desktop and it looks good. So I added in power bi service. 

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host_name)(PORT=port_num))(CONNECT_DATA=(SERVICE_NAME=service_name))) 

[v-yiruan-msft]

Hi @hninhninshwe ，

On-premises gateway is required when connect to Oracle, and please make sure Oracle is installed in the same machine with the one which on-premises gateway located in. You can refer the following second documentation to configure the related data source.

Power BI data sources

Manage your data source - Oracle

Best Regards

Rena