Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
Hi @Anonymous ,
Yes Thanks, it got resolved after installing the ODAC.
Regards.
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
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.
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
In windows search for env variable.
https://helpdeskgeek.com/windows-10/add-windows-path-environment-variable/
I added following for client
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |