Forum Discussion

deepan_94's avatar
deepan_94
Frequent Visitor
8 years ago

Direct Query is not working while Connecting to Oracle database

Not able to connect to the Oracle DB using Direct Query Mode   Feedback Type: Frown (Error) Timestamp: 2017-12-19T10:52:51.0660494Z Local Time: 2017-12-19T16:22:51.0660494+05:30 Session ID: ...
General Comment
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
8 years ago

deepan_94,

Based on your error message, you are using Power BI Desktop for Power BI report server to connect to Oracle. I test the scenario as yours, everything works well. 

Could you please verify that if you can connect to Oracle from Oracle SQL developer? Please make sure that SQL developer is installed on  the same machine with Power BI Desktop.

Regards,
Lydia

  • deepan_94's avatar
    deepan_94
    Frequent Visitor
    8 years ago

    Anonymous

     

    I can able to connect to the Oracle. Both the applications were installed on the same machine.

    Also, I'm not able to connect power BI Desktop to Oracle.

    It's showing the same error message.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      deepan_94,

      Does the error occur when you use import mode? And how about you connect to other data sources in Power BI Desktop?

      Regards,

      Lydia

      • deepan_94's avatar
        deepan_94
        Frequent Visitor
        8 years ago

        Anonymous

         

        In import mode it was working fine.

        When I Tried with SQL Server it was working.

        But in Oracle I'm getting the error.

         

        Regards,

        Deepan