Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Continuous Object reference not set error using Oracle database connection in Power Query

Hi, I've been working from some days with an Oracle database connection in Power Query. I've PBI desktop to 64-bit and I've installed the Oracle client/ODAC software and the Oracle XE database on m...
Need Help
lbendlin's avatar
lbendlin
Super User
5 years ago

In Power BI you can only test it by connecting via the TNS entry.  You can always use sqlplus or tnc on your PC to make sure the desktop can talk to the database.  I am not aware of other ways of troubleshooting.  If you have a Power BI Pro license you can open a Pro ticket with Microsoft support.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi, I don't know "tnc" (what is it?) and sqlplus requires only a username and the related password. I've used the gui tool "SQL Developer".

    How could I use SQL Plus at better?