Forum Discussion

dennisr's avatar
dennisr
Advocate II
10 years ago

'Oracle.Databases.Client' could not be instantiated

In PowerBI, I can "Get Data", and the columns appear in the "Fields" section. However, when I select a field, this error appears:   "Could not load the data for this visual" Error:The managed prov...
dennisr's avatar
dennisr
Advocate II
10 years ago

I instaled the ODAC121024_x64.zip.   I verified that my PATH was updated with the leading 

 c:\OracleClient\product\12.1.0\client_1;c:\OracleClient\product\12.1.0\client_1\bin;

 

I still get the same error with the visual.

dennisr's avatar
dennisr
Advocate II
10 years ago

I "frowned" the error this time, and got a reply back...

 

...This is an issue several customers have hit. We've fixed it in the upcoming release....

[I asked for ETA, and they said ...]

...our monthly release will be available on Thursday, May 26th. You will be able to download it at:  https://www.microsoft.com/en-us/download/details.aspx?id=45331

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Problem exists at this moment at our company when files are based on direct query. Still looking for the solution. Any help????

     

  • Knud's avatar
    Knud
    Frequent Visitor
    10 years ago

    I have exactly the same problem.

     

    The Power BI Desktop version I use is 2.36.4434.381 64-bit (juni 2016).

    So the problem is still not solved?

  • mike_honey's avatar
    mike_honey
    Memorable Member
    9 years ago

    Actually it's working fine for me on multiple machines.  The key seems to be installing and configuring that 64-bit ODAC client driver on all machines.

  • Topgun's avatar
    Topgun
    Regular Visitor
    9 years ago

    Hi All,

     

    I still get this error. We installed ODAC 12c release and installed Oracle Data Provider for .Net 12.1.0.2.0. And from Power BI Edit Query, I preview data, but when I create Visual report, I got error 

    Error Message:
    The managed provider 'Oracle.DataAccess.Client' could not be instantiated. Unable to find the requested .Net Framework Data Provider. It may not be installed.

     

    Here is detail. Did I miss any setup? Appreciate any help. thx

     

    Tom

     

  • Topgun's avatar
    Topgun
    Regular Visitor
    9 years ago

    Hi,

     

    I faced same issue now. I have ODAC 12c installed, and my Power BI desktop version is Version: 2.42.4611.901 64-bit (January, 2017). In Power BI desktop. I can view data in Edit Query windows, but when I added to visual, I got error The managed provider 'Oracle.DataAccess.Client' could not be instantiated. Unable to find the requested .Net Framework Data Provider. It may not be installed. I saw you solve the issue by configure ODAC, here is what I have ODAC component installed. Not sure missed anything. 

     

     

    Appreciate any help.

     

    Thanks

    Tom

  • mike_honey's avatar
    mike_honey
    Memorable Member
    9 years ago

    Is your Oracle install 64-bit?

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous , i also have same problem for direct query, is it solved for you.

    If yes, can you please let me know 

     

    Thanks,

    Soumya

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Check if server password is not expired. That was the problem in our case.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Installing the ODAC client resolved our issue.

Related content