Forum Discussion

RakeshP's avatar
RakeshP
Helper I
10 years ago
Solved

Having issues with Connect to Oracle database

Hi ALL,   I am trying to connect to oracle database from Power BI Desktop(PBID), but it is throwing below error.   Unable to connect   we encountered an error while trying to connect   Detail...
Need Help
pqian's avatar
pqian
Microsoft Employee
10 years ago

leeann_g Can you post the Query's full expression here? (View->Advance Query Editor)

leeann_g's avatar
leeann_g
Frequent Visitor
10 years ago

I was able to get this to work by manually changing the Date/Time data type and format to the Date data type. It seems that the Date/Time format type we are using in our Oracle system (date time (G)) was not working with the tool and resulted in that error message. I can't provide the full query detail here unless I strip all connection related info. Would that be enough for you to work with?

  • mcguija's avatar
    mcguija
    Helper III
    9 years ago

    Hi,

     

    I am having issues with the issue orginally logged in this thread.  I do have the correct version of Oracle client installed.

     

     

    I also added the install directory to my PATH.

     

     d:\oracle;D:\oracle\bin\;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft\Web Platform Installer\

     

    Rebooted to ensure if caugth

     

    I also connected to the DB using Oracle SQL developer no problem.

     

    HELP!

     

     

     

    Here is the error.

     

    Unable to connect: We encountered an error while trying to connect to CDS01_12c_DEV. Details: "Cannot connect to the mashup data source. See error details for more information."Hide details
    Activity ID: d50939a9-69f5-4195-a414-43db4f5e60ef
    Request ID: 68d6c7f3-0e04-1481-8410-b46b3215f469
    Cluster URI: https://wabi-canada-central-redirect.analysis.windows.net
    Status code: 400
    Error Code: DM_GWPipeline_Gateway_MashupDataAccessError
    Time: Fri Dec 16 2016 11:05:24 GMT-0500 (Eastern Standard Time)
    Version: 13.0.1700.811

    Underlying error code: -2147467259
    Underlying error message: The provider being used is deprecated: 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.'. Please visit https://go.microsoft.com/fwlink/p/?LinkID=272376 to install the official provider.
    DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
    Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error

    Troubleshoot connection problems

  • mcguija's avatar
    mcguija
    Helper III
    9 years ago

    Hi,

     

    I am having issues with the issue orginally logged in this thread.  I do have the correct version of Oracle client installed.

     

     

    I also added the install directory to my PATH.

     

     d:\oracle;D:\oracle\bin\;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program Files\Microsoft\Web Platform Installer\

     

    Rebooted to ensure if caugth

     

    I also connected to the DB using Oracle SQL developer no problem.

     

    HELP!

     

     

     

    Here is the error.

     

    Unable to connect: We encountered an error while trying to connect to CDS01_12c_DEV. Details: "Cannot connect to the mashup data source. See error details for more information."Hide details
    Activity ID: d50939a9-69f5-4195-a414-43db4f5e60ef
    Request ID: 68d6c7f3-0e04-1481-8410-b46b3215f469
    Cluster URI: https://wabi-canada-central-redirect.analysis.windows.net
    Status code: 400
    Error Code: DM_GWPipeline_Gateway_MashupDataAccessError
    Time: Fri Dec 16 2016 11:05:24 GMT-0500 (Eastern Standard Time)
    Version: 13.0.1700.811

    Underlying error code: -2147467259
    Underlying error message: The provider being used is deprecated: 'System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.'. Please visit https://go.microsoft.com/fwlink/p/?LinkID=272376 to install the official provider.
    DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
    Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error

    Troubleshoot connection problems