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.
Dear all,
I am a beginner in using Power BI Tool
i have a problem in connecting to an Oracle Database
i have Oracle Database version 9.2.0.1.0 installed on windows server 2003
i installed Power BI Desktop tool version 64x on my PC which is also 64x
when pressing home>get data> more > Oracle Database
it gives me that error
"The recommended provider ('Oracle.DataAccess.Client') is not installed. You can continue with your current provider, however it has been deprecated and may not work properly."
so what i can do exactly
what is wrong
please explain in details as i am still beginner
Thanks
You need to install the oracle client.
Refer
https://docs.microsoft.com/en-us/power-bi/desktop-connect-oracle-database
This is the client.
https://www.oracle.com/database/technologies/odac-downloads.html
After installing, please make sure you Add Path in the environment variable path, otherwise you will keep on getting this error.
These are my locations, Change as per need
i don't know which version should i install
from that link
https://www.oracle.com/database/technologies/odac-downloads.html
also should I install this on my PC (the host of Power BI Desktop) or on the server side
Thanks
Hi @EmadBsb_1 ,
Here are some posts may help you:
Unable to Install Oracle Client for use in Power BI desktop;
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |