Connect to Oracle Autonomous Data Warehouse Cloud is supported?

[Anonymous]

I would like to connect to Oracle Autonomous Data Warehouse Cloud with Power BI. Is this possible?

Is this possible? Anybody tested? Or any article saying it is possible.

Ken

[Anonymous]

Hello guys,

I'm not able to refresh dataset (on demand or with scheduling) !!

• I follewed all theses steps here and everything works fine in power bi desktop.
• Then I installed and configured on-promises Gateway, here also everything works fine in Power BI Server.
• So I'm able to create a report (with import mode) and publish it.

But when I try to refresh dataset, I'm getting this error:

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Oracle: ORA-28759: failure to open file"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Oracle"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"adwprodonehr_medium"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"ORA-28759: failure to open file"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: MAP_VALUES.

Any suggestions?

Thanks

[Anonymous]

Yes, you can.

You can use import mode, but I'm encountered "couldn't load the model schema" in DirectQuery mode.

[Anonymous]

I fixed the soltuion in DirectQuery mode, when install Oracle provider/driver have to check the box "Configure ODP.NET at machine-wide level" in ODP.NET step.

[Anonymous]

@Anonymous,

Have you tried the Oracle connector in Power BI Desktop? Based on this article, as long as you install required Oracle client in the Power BI Desktop machine, you are able to use Oracle connector in Desktop to connect to Oracle Autonomous Data Warehouse Cloud.

In addition, as per this article, it is possible to create ODBC dsn for Oracle Autonomous Data Warehouse Cloud. In this case, you can use ODBC connector in Power BI Desktop to connect to the dsn.

Regards,
Lydia

[Anonymous]

hi,

I have created ODBC connection to ADW and tested it working as well on the server where Gateway is running.

But adding that data source in Azure Power BI under that Gateway fails with error for which I do not find an troubleshooting tips. Its a bit urgent if you could help.

Error:

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Show details

Troubleshoot connection problems

Show Details:

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details

Activity ID:	9ad34f1d-fb8c-4eb5-add1-32bbe92f6c87	Request ID:	b82f1c89-ec0d-aa82-c1d4-759107b9ad5c	Cluster URI:	https://wabi-west-europe-redirect.analysis.windows.net/
Status code:	400	Error Code:	DMTS_PublishDatasourceToClusterErrorCode	Time:	Thu Dec 05 2019 06:09:31 GMT+0000 (Greenwich Mean Time)	Service version:	13.0.11499.187	Client version:	1911.3.022 GWAYSRV: Connection string is not supported. Troubleshoot connection problems How show the ODBC connection string be provided then?

[Anonymous]

Hi Lydia,

I found the fix in your post ..but I thought it would be good to put here as reference in this thread, so adding it here as well.

https://community.powerbi.com/t5/Service/Enterprise-Gateway-with-ODBC/td-p/98959

Thanks