Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Database Connectivity with POWER BI

santhosh TJun 3 2021

Hi Experts,

To connect Oracle Database with Power BI Desktop, what and all to be installed in that local machine.

I want to connect the Oracle Database of 19C(19.3.0.0) with Power BI Desktop (Version: 2.88.1144.0 64-bit ). Power BI Desktop was installed in my local Windows Machine( Server 2012 R2).

I have installed only Oracle ODAC (64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64 - 287 MB) from this link (https://www.oracle.com/database/technologies/odac-downloads.html) and updated the tnsnames.ora file (E:\app\client\famis\product\12.1.0\client_1\Network\Admin) accordingly.

Now, When I opened Power BI Desktop and trying to connect the below message is appearing. Please guide me if anything I am missing.

santhoshpowerbi_0-1622699202549.png Thank You

Comments

ytf-Oracle
Answer

Hi there,

You also need to download instantclient-odbc-windows.x64-12.2.0.1.0-2.zip from the same web page. And then unzip instantclient-basic-windows.x64-12.2.0.1.0.zip and instantclient-odbc-windows.x64-12.2.0.1.0-2.zip into the same directory (eg intantclient_12_2). Then follow the instruction in ODBC_IC_Readme_Win.html which you can find under directory intantclient_12_2.

Hope it helps.

Marked as Answer by 2d2a22ee-1912-448d-b5be-9f5151a990e9 · Sep 27 2020
Ken_553995

Very odd that Instant Client for Microsoft Windows (x64) 64-bit  shows one basic OR one basic lite file and your response refers to a hidden file to obtain the elusive odbc_install.exe.

And the articles for installing on windows are cryptic and arcane requiring directories to be created, path variables, windows registry settings etc.  I do miss the old days where everything you need was in one place and installation was straight forward i.e. setup.exe with wizards without requiring convoluted multiple external resources to determine how to utilize a driver.

The sad thing is that on that page, there is no feedback component to ask customers if there was a problem procuring resources, installation etc resulting in wasted time for those unfamiliar with the new process.

Any ways grateful for a link and to begin the fourth attempt in trying to install an Oracle ODBC driver to use with Excel for my client. Sigh

1 person found this helpful
ytf-Oracle

Hi Ken,

Sorry to hear that you had troubles to install Oracle ODBC driver. The installing instruction has been updated to make it clearer that two packages are required. Please see: ODBC Instant Client Release Notes

Thanks for your valuable feedback.

dc579d6e-459f-41ec-9b12-1695f02ca943

Hi, I'm Covi.

I'm in the process of trying to install Oracle ODBC x64-12.2.0.1.0 and X32. driver onto Windows Server 2012.  This process is the most unsuccessful process I've ever encountered installing windows server bits and has consumed much of my time.

Ken_553995 is right on,

Oracle I don't think you could have made this anymore difficult!

How about a simple ODBC installer that does everything that's needed?  No manual anything other than click install.

Thanks - Covi

1 person found this helpful
Thiyagu - Oracle

HI

You can find installation instruction under

Instant Client for Microsoft Windows (x64) 64-bit

Once you edthe 64 bit Client, then you need to start the ODBC Administrator from C:\Windows\System32\odbcad32.exe for 64 bit Oracle ODBC driver.

create DSN and test

Thanks

Thiaygu

1 - 5

Post Details

Added on Jun 3 2021
#bi, #database, #heterogeneous-connectivity, #report
0 comments
318 views