Error when i want to get data from an Oracle database

[Anonymous]

Hello

When I try to get data from an Oracle database I get this error message : 

Details: "An error occurred while reading data from the provider : 'The object reference is not set to an instance of an object.'"

Do you know how to fix the problem ? 

Thank in advance, 

Charline

[v-xiaotang]

Hi @Anonymous 

I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

Also, please check the solution mentioned in this link, https://stackoverflow.com/questions/47880625/powerbi-object-reference-not-set-to-an-instance-of-an-object

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Anonymous , Install Oracle driver. Add Entry to tnsnames.Ora. Add install folder to env variable

also refer steps in description of problem

Connecting with Oracle
https://community.powerbi.com/t5/Desktop/Getting-Power-BI-Desktop-to-work-with-Oracle-ODAC-after-version/m-p/1918220#M733122