Visualization error in Direct Query Mode

[Anonymous]

Hi All,

I can able to see the chart in import mode but when i am trying to connect that in Direct query mode then my chart is showing up below error. Any suggestions on the next step?

Thanks in Advance

[v-eachen-msft]

Hi @Anonymous ,

Could you please tell me if your problem has been solved? If so, could you please mark the helpful replies as Answered?

[Anonymous]

Yes Thanks, it got resolved after installing the ODAC.

Regards.

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

Did you install the right ODAC? Here is the link :

https://www.oracle.com/database/technologies/odac-downloads.html

Select the right version. Here is also a similar case as yours for your reference.

https://community.powerbi.com/t5/Desktop/Oracle-DataAccess-Client-direct-query-error/m-p/757448

[amitchandak]

Can you check that you are able to connect to oracle from the same machine you are running power bi desktop. If this from power bi desktop.

Also, make sure that the oracle client path has been set in the env variable.

[Anonymous]

Hi @amitchandak ,

Yes i am able to connect to oracle from the same machine in which i am running power bi desktop.

Where/How to check the oracle client path set in the env variable?

Thanks

[amitchandak]

In windows search for env variable.

https://helpdeskgeek.com/windows-10/add-windows-path-environment-variable/

I added following for client