Forum Discussion
Power BI Reporting Server Data Source for oracle
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.
Hi Riccardo,
Thanks for you reply!!!
FYI, I'm using windows 10 Pro, I can connect oracle database using oracle client, so there is no issue in TNS names.
As you said, I have removed 64-bit ODAC and ODP.Net from my machine and installed 32-bit ODAC/ODP Versions, this time i couldn't connect even datasource itself.
Please let me know is there any restrictions/specification on Power BI report server while connecting to oracle server?
Hmm, sorry you're still having trouble. At this point, it's difficult to know what might be missing without investigating hands-on. Could you open a case with Microsoft Support so we can do so? It'd be great to get to the bottom of it and improve our documentation if necessary.
Hi Team,
i can connect on premise oracle databse using power BI reporting server. Thanks for you help team.
Now i'm facing new issue, could i connect Microsoft azure oracle using power BI report server
Beacuse , there is no option to select the azure oracle data source connection type in power BI report server?
You should be able to use the Oracle Database connector to connect to an Oracle database running in Azure.
Thanks Riccardo,
Could you please share the sample connection string to connect Azure oracle server