Forum Discussion
DataSource.Error: An error happened while reading data from the provider
Hello everyone,
When I try to refresh my queries on the PowerQuery editor and with Oracle as the source, I get this problem:
DataSource.Error: An error happened while reading data from the provider:'Object reference not set to an instance of an object.'
Details:
DataSourceKind=Oracle
DataSourcePath=tdmpsb02
My connection to Oracle is working fine and I don't know why I can't refresh it without causing problems.
I have tried reinstalling my Oracle, PowerBI, I have the 64-bit version on both systems.
I also try this solution:
Locate and copy the oraons.dll file in ‘<>product\12.2.0\client_1’ on your oracle install path
Paste the file into the ‘<>product\12.2.0\client_1\bin directory
Thank you for your help
Hi remyc - Verify that the correct version of Oracle Data Access Client (ODAC) or Oracle Instant Client is installed. Both Oracle and Power BI should be 64-bit versions, which you've already confirmed.
If you reinstalled Oracle, ensure that the PATH environment variable includes the path to the bin directory of your Oracle installation (for example, C:\Oracle\product\12.2.0\client_1\bin).Verify that the correct version of Oracle Data Access Client (ODAC) or Oracle Instant Client is installed. Both Oracle and Power BI should be 64-bit versions, which you've already confirmed.
If you reinstalled Oracle, ensure that the PATH environment variable includes the path to the bin directory of your Oracle installation (for example, C:\Oracle\product\12.2.0\client_1\bin).checking logs from both Oracle and Power BI might give more detailed insight into the root cause.
reference solved threads FYR:
Solved: PowerBI desktop 64Bit oracle connection error Obj... - Microsoft Fabric Community
Solved: Oracle: Object reference not set to an instance of... - Microsoft Fabric Community
Solved: Re: PowerBI desktop 64Bit oracle connection error ... - Microsoft Fabric Community
Object reference not set to an instance of an obje... - Microsoft Fabric Community
Solved: Re: Oracle: Object reference not set to an instanc... - Microsoft Fabric Community
Hope the above information helps.
2 Replies
Hi remyc - Verify that the correct version of Oracle Data Access Client (ODAC) or Oracle Instant Client is installed. Both Oracle and Power BI should be 64-bit versions, which you've already confirmed.
If you reinstalled Oracle, ensure that the PATH environment variable includes the path to the bin directory of your Oracle installation (for example, C:\Oracle\product\12.2.0\client_1\bin).Verify that the correct version of Oracle Data Access Client (ODAC) or Oracle Instant Client is installed. Both Oracle and Power BI should be 64-bit versions, which you've already confirmed.
If you reinstalled Oracle, ensure that the PATH environment variable includes the path to the bin directory of your Oracle installation (for example, C:\Oracle\product\12.2.0\client_1\bin).checking logs from both Oracle and Power BI might give more detailed insight into the root cause.
reference solved threads FYR:
Solved: PowerBI desktop 64Bit oracle connection error Obj... - Microsoft Fabric Community
Solved: Oracle: Object reference not set to an instance of... - Microsoft Fabric Community
Solved: Re: PowerBI desktop 64Bit oracle connection error ... - Microsoft Fabric Community
Object reference not set to an instance of an obje... - Microsoft Fabric Community
Solved: Re: Oracle: Object reference not set to an instanc... - Microsoft Fabric Community
Hope the above information helps.
Hi remyc
Did rajendraongole1 's method solve your problem? If yes, could you please mark it as solution? This will help more users who are facing the same or similar difficulties. Thank you!
If you still have questions, please feel free to ask me.
Best Regards,
Yulia Xu
