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!

[@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!

[@battulapavan8700]

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

[@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. 🤣

[@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

[@RajKumar-ux1cu]

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

[@gospelchristjesus3497]

Thanks a lot it works perfecly!

[@radhikagupta7314]

Thank you ! It worked

[@KleitomAntonioMachadodeSouza]

Thank you very much !

[@ricardosiementcoski8122]

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

[@sabyasachipatnaik147]

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

[@swagconundrum]

Super helpful! Appreciate you making this!

[@wendirichmond-conley9389]

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

[@JenniferQi-qn4fv]

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

[@russelpomahualilapa]

Muy bueno, funcionó 👍

[@benjaminnaderi4292]

Worked like a charm. Thank you!

[@mrshmeluavichus9367]

Thank you, @Matthew Yu

[@alfrednguyen720]

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

[@Anjell_Player]

Thank you so much You're amazing man

[@CharlieFosterOffdenson]

This is so helpful, thank you so much for this

[@alexfigirova]

Thank you!!! Great summary!

[@khuramwani6832]

Thanks man. It helped a lot

[@camillenabeleone2601]

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

[@BrunaSilva-nw4yx]

thanks a lot!

[@ailtoncabral8878]

u'r a genius. Tks so much!

[@1spunch]

you are the best Thank you.

[@carlosalvarado6258]

Excelente muchas gracias me ayudo para poder conectar Power Bi.

[@damarmuhammet]

Thansk alooooot... very good job!

[@jolly170876]

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

[@leonardosouza8396]

Nice, this is a very insteresting video

[@vitor10004]

Tks a lot!!!! Save my day!

[@shahzaibmubariz6494]

thanks

[@Pursuit_of_Insights]

Thanks, that was helpful

[@MegaGuiguito]

thank you you helped me a lot

[@facundogorla8772]

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?

[@roastytoasty8815]

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

[@_graymatter__]

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

[@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?

[@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?

[@AlexanderPoznanski]

Super! Many thanks!

[@nitin-wb7lt]

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

[@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.

[@aamiransarii]

many Thanks buddy

[@Atifbutt65]

I am thinking what if this video is not posted. I would have trying for hours. Thanks Matthew

[@subhi_sadiyev]

Great video 👍

[@afzaalawan]

great

[@nelinxumalo5969]

THANK YOU!!

[@vghc]

Thank you!!!! Thank you!!

[@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

[@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 ?

[@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

[@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?

[@Stratoos23]

I love you chinese man

[@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?

[@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

[@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.

[@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.

[@hariskeelan9940]

amazing!

[@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?

[@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

[@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 ?

[@sreddibathuni]

Great !

[@kenzasouabni7410]

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

[@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.'

[@ariespinal]

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

[@priyavishalkulkarni2415]

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

[@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?

[@lekhasharma3795]

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

[@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.

[@chenzhenyew6874]

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

[@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.

[@pl4195]

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

[@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

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

[@aaddiis45021]

how about oracle cloud

[@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.

[@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

[@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.

[@advent7324]

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

[@justwest]

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

[@andreasuarez2514]

Thanks! It worked for me