Forum Discussion
Power BI Reporting Server Data Source for oracle
Hello: I am not seeing connection info for Oracle from the drop down & only i see is Oracle Essbase, attached is the screenshot. I need help how to create Oracle connection\string in Power BI...
Hi Riccardo,
As you said, i have installed 64-bit version of ODAC including ODP.NET in my machine, After restarting the powerBI reporting service, i can select the oracle database in power bi report web page and i have created the oracle database connection, eventually it got succeded, but i couldn't create a dataset using this datasource, i'm getting TNS - ora identifier issue, while i'm connectig via report builder3.0.
Whereas the report server is 64-bit, the client tools (Report Builder and Visual Studio) are 32-bit, so on the client side, you need the 32-bit version of ODAC/ODP.NET.