Power BI: How to Connect to Oracle Database (Part 1)

[@maksimgill9915]

This is how this should be documented on the Microsoft site. Great work!

[@nyanyaa8043]

When I see intelligent video I know. This video is to the point. He never assumed you know. He took time to explain every step. Thank you matthew

[@olaiti6331]

This is the most helpful video I have seen till now that targeted the issues i had earlier during connection including being able to connect to 19c and not to 11g. Thanks a lot for this

[@alparkson5494]

Matthew, you are the only person that helped with this. Thank you so much. The problem I was having was in the string you enter when prompted for the server name. You are my hero!

[@battulapavan8700]

Thanks very much Matthew, for your video. The format of giving server details helped me a lot.

[@Data_Is_Values]

Noble, I'll have to put the subtitles in Portuguese - Brazil! But it helps me a lot what I wanted! You are more than 10!

[@rrhfgjhgfjmhjghkmh]

thanks a lot brother , I was stuck trying to connect but the new connection format you specified helped a lot I was stuck for a month

[@andypickard7314]

Thanks! You got me over the Oracle connect hump!

[@alman34]

This what super helpful. Thank you. I've never heard anyone refere to an error window as a complaint before, I am going to be using that from now on. 🤣

[@RajKumar-ux1cu]

Thanks a lot... It is simple & working. I spent many hours to figure out how to fix.

[@tiffanycui1088]

Very helpful Matthew. I have a question, can we create the exact same report connecting to two different Oracle DBs? For example, I create a report connecting to one Oracle DB, then I want to create the exact same report connecting to a different Oracle DB. Can I just copy the one I created and changed the credentials to another Oracle DB?

[@ricardosiementcoski8122]

Dude, your content saved me! Thanks for sharing that with us

[@swagconundrum]

Super helpful! Appreciate you making this!

[@sabyasachipatnaik147]

Excellent. It worked. This is a great help Matthew.

[@RyuzakiF]

Hi, I'm having the ORA-12514 error. When you show how to use the host:port/SID can I connect ONLY doing that or do I have to also copy the tns.ora file?

[@pabeader1941]

Thank you for this video. I get to keep my job. I have a question though. Is there a way to speed up the refresh and import from Oracle?

[@fishleaf]

You are note alone! I posted a thread a few years back, and it looks Microsoft didn't deep dive and provide a good solution from the application level yet community.powerbi.com/t5/Desktop/Very-Slow-Oracle-Connection-Speed/td-p/72510 There are some workarounds we can do-- Make your Power BI Desktop machine "physically" close to the Oracle Database. For example, if your Oracle database is in Boston, then your Power BI Gateway should be in US-EAST region instead of US-West; developers VPN should also connect to US-East VPN server. I Personally also used Remote Desktop to RDP into a machine of the same Data Center of that Oracle. -- My speed increase at least 20 times. I would recommend to give it a try.

[@melikeertunc6093]

Hi, Thanks for the video ! After installing Oracle Client, my date format was corrupted. I am getting "not a valid month" error in my SQL query in Excel. How can I change the date format of ocmt?

[@luismelendez8205]

Hi there, I am getting the following error message : "Oracle: ORA-12170: TNS:Connect timeout occurred." Would you happen to know how I can solve this? Thanks in advance for your help.

[@turtleturtle4909]

What user owns the Oracle Base and Oracle Home paths? It appears that when I install the ODAC as myself, other users cannot use it. I need to set this up on hundreds of desktops. Do you have any recommendations / suggestions?

[@wendirichmond-conley9389]

Thank you so much, Matthew! This was so helpful!

[@nitin-wb7lt]

How do I use if I have service name instead of SID?

[@Anjell_Player]

Thank you so much You're amazing man

[@JenniferQi-qn4fv]

Thank you!!! This is very clear and helpful!!!

[@benjaminnaderi4292]

Worked like a charm. Thank you!

[@roastytoasty8815]

Hi everyone. I’m getting the error “TNS: Connection Closed” in PowerBI. Does anybody know how to resolve this?

[@alfrednguyen720]

Thank you so much !!! Your video save my a whole day bro :D

[@vitorvitafor1125]

Thank you Matthew, very helpfull your video. But i'm having a trouble with the connection because when i try to update my date base, return me this error: An error occurred while reading data from the provider: 'Object reference not defined for an instance of an object.' What can i do to solve this?

[@russelpomahualilapa]

Muy bueno, funcionó 👍

[@gospelchristjesus3497]

Thanks a lot it works perfecly!

[@asnlim]

The company where I work change the program to Oracle. I work and the receiving are. How I can improve my learning on this are? please help. Thank you. drr

[@davidhenriquebarboza4112]

Hey, I'm having a problem with the installation process. When I run setup.exe it starts cmd, but after closing it does not open the oracle window to do the installation.

[@atulsahu1341]

Hi , I am also facing same issue. Were you able to fix this issue and installed it? Sorry to bother you on this old thread

[@andreasuarez2514]

Thanks! It worked for me

[@Liftlikekong]

have connected power bi desktop with oracle database and when i try to load data from oracle db to power bi it loads only 4285 rows i expect to load 7lakh rows into power bi desktop

[@kenzasouabni7410]

dans la fenêtre Navigateur je ne trouve pas le dossier approprié pourquoi?

[@archu3956]

Hi I am able to do it with second method ; however my header is different for some coloumn so it is showing error . Do u know how to resolved that error ?

[@adi007full]

Hello Matthew, i dont have SID available in my tns file and still my colleague is able to connect. can you suggest a way to establish connection without using SID.

[@danielweikertsn1615]

Great work thanks. How do we set up the gateway for the oracle connection to allow schedule refresh? Can you please show that? Thank you

[@fishleaf]

Please check out this video for the step-by-step guide for Setting up the gateway kzbin.info/www/bejne/f5iceY1oq9N6rs0 It can definitely work and we use the set up for our day-to-day Production Reports.

[@Pursuit_of_Insights]

Thanks, that was helpful

[@senex7777]

Hi, is there a way to save my database credentials in Power BI so I don't have to copy them every time I want to connect?

[@lekhasharma3795]

Can I use oracle express edition in place of oracle 9 ? I want to use it power BI

[@camilapaes16]

Mesmo seguindo esses passos ainda não consegui conectar ao banco. Aparece esse erro Ocorreu um erro ao ler dados do provedor: 'Referência de objeto não definida para uma instância de um objeto.'

[@camillenabeleone2601]

Thank you so much !! You helped me so much :)

[@1spunch]

you are the best Thank you.

[@CharlieFosterOffdenson]

This is so helpful, thank you so much for this

[@pl4195]

brother, do you know how to automate oracle with power automate desktop? I saw some youtuber do it with SAP thankyou

[@mingjiezhou4510]

Matthew, if I have a TLS connection with a secure port of 1523, how do I configure it in the connection detail box from Power BI? Do I need to add a line to specify the security detail?

[@shahnidk2288]

Hey same here. How did you connect?

[@ailtoncabral8878]

u'r a genius. Tks so much!

[@sahilsinghal9472]

Wow. This is amazing. I’ve been having the same issue. Can I ask you one question - if I use your second method to connect to oracle and then upload to Power BI server premium workspace , will I be able to schedule report refresh?

[@fishleaf]

Yes, we use this method for our Production server and we didn't have any issue. Note: To connect to an Oracle Database, you will need to set up a Power BI Gateway. Please make sure the connection string you entered in the Power BI Gateway setting page is the same as the connection string you entered in Power BI Desktop. I have another video on Power BI Gateway setup: kzbin.info/www/bejne/f5iceY1oq9N6rs0

[@alexfigirova]

Thank you!!! Great summary!

[@jolly170876]

Thanks mate...it really helped...cheers

[@khuramwani6832]

Thanks man. It helped a lot

[@priyavishalkulkarni2415]

Details: "Oracle: ORA-12154: TNS:could not resolve the connect identifier specified" Error while connecting to Oracle.

[@chenzhenyew6874]

Is it possible to connect Oracle DB to Power BI using DirectQuery?

[@radhikagupta7314]

Thank you ! It worked

[@damarmuhammet]

Thansk alooooot... very good job!

[@bilelchaibi3832]

Thank you Matthew, but I'm having a following error: Detail:"happened while reading data from the provider:' Object reference not set to an instance of an object.' " Any idea to solve this ?

[@walissongomes4940]

For posteriority: According to the page learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-oracle-database#troubleshooting: "If you downloaded Power BI Desktop from the Microsoft Store, you might be unable to connect to Oracle databases because of an Oracle driver issue. If you encounter this issue, the error message returned is: Object reference not set. This is an issue with how Oracle driver works in Windows UWP Apps." I had this issue and, after reinstalling using the download center, it worked.

[@leonardosouza8396]

Nice, this is a very insteresting video

[@KleitomAntonioMachadodeSouza]

Thank you very much !

[@yashadanimkar3762]

Hi Matthew, I followed the second method and I was able to connect to Oracle database but now its stopped working and is giving error as :"TNS:could not resolve the connect identifier specified". Can someone please assist ?

[@aakashmohan9827]

Have you got any solution? it will help me a lot.

[@vitor10004]

Tks a lot!!!! Save my day!

[@MegaGuiguito]

thank you you helped me a lot

[@davidBarrel]

everthing went well for me until the end : reference to non instantiated object ... what could happend?

[@KedielSanchezMariano]

It could be that (At 5:54 in the video) You should select (enable) "Configure ODP.NET and/or Oracle Providers for ASP.NET at machine-wide level" option.

[@davidBarrel]

@@KedielSanchezMariano hi, thanks finally it was the powerBI, I had to uninstall and reinstall it from microsoft download center instead of the micr. store. And it worked

[@subhi_sadiyev]

Great video 👍

[@mrshmeluavichus9367]

Thank you, @Matthew Yu

[@AlexanderPoznanski]

Super! Many thanks!

[@_graymatter__]

Oh lord. Why didn't I find you earlier.

I tried to run setup.exe as administrator but the application closes after the black verification screen. Does anyone already saw that? I got a tip to disable my antivirus software, but it didnt work as well.

[@atulsahu1341]

Hey, were you able to install it after this issue. Becasue i am also facing this now . Sorry to bother on this

[@BrunaSilva-nw4yx]

thanks a lot!

[@aamiransarii]

many Thanks buddy

[@aaddiis45021]

how about oracle cloud

[@nelinxumalo5969]

THANK YOU!!

[@vghc]

Thank you!!!! Thank you!!

[@safwanmohammed372]

Run As administrator to avoid error even after installing ODAC 6:59

[@KedielSanchezMariano]

That and (at 5:54 in the video) you should select (enable) "Configure ODP.NET and/or Oracle Providers for ASP.NET at machine-wide level" option.

[@shahzaibmubariz6494]

thanks

[@hariskeelan9940]

amazing!

[@Stratoos23]

I love you chinese man

[@afzaalawan]

great

[@brokejohnnylive1530]

This is not correct. You should not get ODAC error if installed properly on desktop. You should have clicked install the .net stuff, and you should have set up the tns with the OUI.

[@KedielSanchezMariano]

Exactly. After much trial and error I finally got it just recently. The video is pretty useful, just need to add that part.

[@sreddibathuni]

Great !

[@janinevega3139]

No me funciono :(

[@KedielSanchezMariano]

(En 5:54 del video) selecciona la opción "Configure ODP.NET and/or Oracle Providers for ASP.NET at machine-wide level". Asegúrate de que tengas el archivo tnsnames.ora bien configurado/escrito, y que uses el nombre de esa conexion cuando estes en power bi.

[@kingkoolkris]

basically counter >9000 xD

[@advent7324]

Waste of time! After nearly 10 minutes you aborted the method you were demonstrating! Wow!

[@carlosalvarado6258]

Excelente muchas gracias me ayudo para poder conectar Power Bi.

[@justwest]

my tnsnames.ora doesn't ask for SID but for SERVICE_NAME

[@ariespinal]

How can I connect Power BI to WMS called Exenta? Please help!!

[@andrescruzquispe]

thanks