Forum Discussion
jvalladares
7 years agoNew Member
Oracle direct query error from app
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 gatewa...
v-yulgu-msft
7 years agoMicrosoft Employee
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