cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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 REPLY 1
Highlighted
Super User II
Super User II

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

@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

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.