Hello everyone, I am pulling my hair out figuring out how to get Power BI to getting to my oracle xe database.
here is my tnsnames.ora file ( I don't care if internet sees it, I have nothing important on my database)
I have already installed the Oracle Client for Microsoft Tools (OCMT) 64 bit for 19c (I can't find OCMT for 21c)
So when I open Power BI and select Oracle database,
I put in my Server which is listed as (HOST = DESKTOP-AA1LD45)
In the credential window, I put in my sys and password, the password is correct because I just tested it in oracle sql developer.
Then I am getting ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
But there thing is that there is no way for me to choose my login as SYSDBA or SYSOPER in a drop down as in Oracle SQL Developer.
Any help would be greatly appreciated.