Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Error while connecting Oracle to Power BI

I have installed Oracle.

Also installed Oracle-Client-for-Microsoft-Tools and ODAC

Now I'm connecting Oracle to Power BI using Oracle Database Connector.
But the following error is occurring.


Is there any solution for it?

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Solution :

    Server - Server Name:1521/xe
    User Name: That which we have given while creating a new connection.
    Password: That which we have given while creating a new connection.

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Power BI only reads from the data source. You should only use a read-only login to Oracle for your connection. Don't use any of these powerful logins.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Solution :

    Server - Server Name:1521/xe
    User Name: That which we have given while creating a new connection.
    Password: That which we have given while creating a new connection.