Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Getting an error when we connect to Oracle data source connection through Direct query mode on PBIRS

Hello All, We're trying to connect to 'Oracle' data source connection through 'Direct Query mode' and it's working as expected on Power BI desktop application, but when we publish this report to Pow...
Direct Query mode
oracle
Report Server
pabeader's avatar
pabeader
Post Patron
5 years ago

Have you installed and tested the oracle drivers on your report server and gateway (if you have one?)

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi pabeader,

    Thanks for checking on this, yes, we had already installed the oracle drivers and tested on our PBI report server, but we don't use/have gateway (server).

     

    FYI - Here, ' import mode ' type and ODBC connection type is working fine, only the issue is with 'direct query' mode. 

    When we test the connection of the report on PBI report server - it's working fine, but when we run the report it's throwing error.

     

    Any suggestions please to fix this.

     

    Thank you !

    • pabeader's avatar
      pabeader
      Post Patron
      5 years ago

      I'm just getting ready to try direct query on oracle.  If I run into trouble and figure it out, I will for sure post about it.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi @pabeader,

        Thank you again, if you've tested this at your end, please let me know the result .