Get Data from ORACLE

[Anonymous]

Hi,

I need to get some data from ORACLE into power bi. I have installed ODAC for 32 bit as I have power BI 32 bit. My tns name file has been configured. However, I want to know what should I edit in the tnsnames file i.e. what should I enter for host, service name and server?

Also, what should I enter when power bi prompts me for server name and username/password.

Thanks,

HV

[mwegener · Accepted solution]

Hi,

may be this helps

https://powerbi.microsoft.com/de-de/blog/publishing-oracle-data-to-power-bi-with-data-refresh/

https://docs.microsoft.com/en-us/power-bi/desktop-connect-oracle-database

https://docs.oracle.com/cd/B28359_01/network.111/b28317/tnsnames.htm#NETRF271

Please give Kudos for support.

If I answered your question, please mark my post as solution, this will also help others.

[Anonymous]

@mwegener Thanks for sharing the blog. It was very helpful