Oracle direct query error from app

[jvalladares]

We are connecting in PowerBI Desktop a dataset from Oracle in mode Direct query and it is working. We publish it in app.powerbi.com and from there it is failing to load the model. Connector in gateway is in green and working. We have the same connector name in gateway than in our desktop, and in import mode it is working fine the refresh. This is the error message we get: No se puede cargar el modelo No se puede cargar el esquema de modelo asociado a este informe. Asegúrese de disponer de conexión al servidor e inténtelo de nuevo. Vuelva a intentarlo más tarde o póngase en contacto con el soporte técnico. Proporcione estos detalles si se pone en contacto con ellos. Identificador de actividad: d0b91441-d206-41ba-9e57-e98f5f554e40 Identificador de la solicitud: 39c6077f-7d6d-5d10-0e3b-501cb31eef63 Id. de correlación: 7d5342a5-6d7a-44db-4b98-523eb0025de3 Hora: Fri Feb 01 2019 18:37:45 GMT+0100 (hora estándar de Europa central) Versión: 13.0.8162.174 URI de clúster: https://wabi-north-europe-redirect.analysis.windows.net

[v-yulgu-msft]

Hi @jvalladares,

What is your Oracle database version? To support Direct Query, Oracle Database should be version 12 and above.

Delete and recreate the data sources in the Gateway and make sure you point them to the right database and server. Please specify the port number when connecting to the server. You can enter as server:port.

Regards,

Yuliana Gu