cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hweb
Frequent Visitor

Help with: Connecting Oracle Database to Power-BI Report Server desktop

Hi,

 

I have struggled with a simple issue for days now. I need to connect to an Oracle Database and retreive data from there, but I cant make it work. I have followed the steps in the following microsoft link: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-oracle-database

My Power-BI report server desktop is 64-bit version which is in line with my computer.

I have downloaded both 32- and 64-bit ODAC 122011 (Not the Xcopy version) and saved them in different directories. I have also tried an earlier version of both 32- and 64-bit ODAC 121024.

- I always tick the box of Machine Wide configuration in the installation of the ODAC

- I always run the installation as administrator

- I even unpackaged the .zip file in temp to isolate the file from onedrive connection

- I have all the TNS information and access in order to connect to the database (I can connect it through oracle developer).

* I always untick the "Oracle Developer Tools for Visual Studio" in the installation of the 32-bit ODAC versions - because i cannot install the ODAC with this ticked due to the fact that I dont have visual studio installed.

 

Despite this, I always get the messege from Power-BI that I have not installed the Oracle client once I try to retreive data from an Oracle Database. Am I doing something wrong or am I missing anything? Do I need visual studio to just connect to an oracle DB?

 

Best,

Hweb

 

1 ACCEPTED SOLUTION
az38
Super User
Super User

@hweb 

I've been experiencing this almost since I started to use combination Oracle + PBI and I still didnt find any workaround

Nevertheless, PBI get data from Oracle correctly despite of this error message


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

2 REPLIES 2
az38
Super User
Super User

@hweb 

I've been experiencing this almost since I started to use combination Oracle + PBI and I still didnt find any workaround

Nevertheless, PBI get data from Oracle correctly despite of this error message


do not hesitate to give a kudo to useful posts and mark solutions as solution
LinkedIn

View solution in original post

hweb
Frequent Visitor

Thank you! I will try

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.