Forum Discussion
Oracle connection error
You need to install the recommended provider which can be found in following links.
- For32-bit versions of Power BI Desktop: 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio (12.1.0.2.4)
- For64-bit versions of Power BI Desktop: 64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64
Please take a look at this document, it should be helpful to you.
Best Regards,
Herbert
Hi, you might be downloading and using the wrong connector, I had the same issue this week.
Try creating a tnsnames.ora file in the client-> clientsname-> oracle version->client_1->Network->Admin directory
Or use the ODCA wizard to create one:
http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
If you prompted to install VS, that means you ahve installed the wrong connector from Oracle.
Maybe this will work for you as well.
I have written a post about my expirience:
http://www.yanaberkovich.com/Blog/connecting-powerbi-desktop-to-oracle/
Is this article still avilable? The link is dead and an archive was not available