Forum Discussion

andershh's avatar
andershh
Advocate I
9 years ago

DirectQuery Oracle database connection issues

Hi everyone,   I have some issues with using DirectQuery for some reports I have uploaded to the PowerBI service, that I hope some of you out there can help me with. Thanks for reading this!   So...
Need Help
ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

andershh check out this blog post and scroll to the end where there is a solution provided to the error message that you're getting. It talks about ssas but maybe it also works in your case of Oracle.

andershh's avatar
andershh
Advocate I
9 years ago

ankitpatira - After taking a look at the troubleshooting guide you linked to, I am almost certain that the issue is due to my firewall blocking some of the ports that the on-premises gateway needs in order to communicate with the PowerBI service. Will mark your post as a solution if testing connection with new firewall settings shows that it works. Thanks for sharing the troubleshooting guide!

 

dimazaid I have tried looking at the log area for the gateway (as specified in the troubleshooting), but there are no logs there. Thanks for the suggestion!

  • andershh's avatar
    andershh
    Advocate I
    9 years ago

    After opening the ports specified in the troubleshooting guide linked to by ankitpatira the problem still persists.

     

    However, dimazaid I was able to find some log files here: C:\Users\PBIEgwService\AppData\Local\Microsoft\on-premises data gateway\Gateway*.log 

     

    Looking at the latest log file it appears this is the main error causing the issue:

    GatewayPipelineErrorCode=DM_GWPipeline_Gateway_DataSourceAccessError --->
    [1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: ArgumentException:<pi>System.ArgumentException: 'integrated security' is an invalid connection string attribute
    ved Oracle.DataAccess.Client.OracleConnection.ParseConnectionString()
    ved Oracle.DataAccess.Client.OracleConnection.set_ConnectionString(String value)
    ved Microsoft.PowerBI.DataMovement.Pipeline.GatewayDataAccess.OracleConnectionProvider.<OpenConnectionAsync>d__0.MoveNext()</pi>

     

    dimazaid or ankitpatira - do you know what might be cause this issue?

     

    • dimazaid's avatar
      dimazaid
      Microsoft Employee
      9 years ago

      andershh,

      Thanks for checking the logs. 
      Will take a look and get back to you.
      Thanks!