Skip to main content

    Power BI

    Completed

    Oracle database connection

    Vote (2) Share
    Leigh Favell's profile image

    Leigh Favell on 23 Mar 2015 18:54:26

    Comments (5)
    Leigh Favell's profile image Profile Picture

    3a98e271 ef2e-4a72-9a29-5ccc2c3db123 on 05 Jul 2020 23:36:47

    RE: Oracle database connection

    Does PowerBI really connect to Oracle Database ? i have been getting this error message for a while now: Oracle: ORA-12154: TNS:could not resolve the connect identifier specified

    Leigh Favell's profile image Profile Picture

    33a5a838 f9a1-48ee-bfaa-33fd17b65ba0 on 05 Jul 2020 22:25:00

    RE: Oracle database connection

    In using the Database connection method, I have connected to Oracle database dbABC on a server dbsServer using specific credentials for dbABC. Now I want to connect to Oracle database dbDEF on the same server (dbsServer) using specific credentials for dbDEF. Power BI seems to default my second connection with the credentials for dbABC, so I can't see the tables in dbDEF. Is there a way to enter my new credentials to connect to dbDEF so I can see the appropriate tables?

    Leigh Favell's profile image Profile Picture

    dd317687 5140-407f-8f09-a44c65b1b357 on 05 Jul 2020 22:17:52

    RE: Oracle database connection

    getting error while connecting to oracle database in BI desktop

    Leigh Favell's profile image Profile Picture

    dd317687 5140-407f-8f09-a44c65b1b357 on 05 Jul 2020 22:17:51

    RE: Oracle database connection

    Oracle: ORA-12154: TNS:could not resolve the connect identifier specified

    Leigh Favell's profile image Profile Picture

    ed26ddd5 84ec-4bd5-bdad-2f7481cf0132 on 05 Jul 2020 22:01:14

    RE: Oracle database connection

    Any idea when the Preview will have the capability to refresh via Oracle ?