Power BI Desktop reconnection to Oracle DB

[tina345]

Hello,

 This might be very basic.

 From options and settings I can make a connection to Oracle DB from Power BI desktop.

 I am still trying to find how do I reconnect once connection is dead?

I usually close power BI desktop and reopen the file.

[parry2k]

@tina345 good to hear it is working. That is what my thinking was and was the reason for my reply. Cheers!!

[parry2k]

@tina345 interesting, I have never seen this, as matter of fact, I never worked with Oracle as the data source in Power BI. Not sure if the database is timing out, sorry I couldn't tell you anything more. I hope someone who is using a similar setup can provide more details.

Also, wondering if you use the same oracle connection from other applications (not sure which one), what happens if this is ideal for a few hours, do you see similar behavior? It will rule out if the issue with Power BI or something how Oracle connection works.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@tina345 not sure what you mean by when the connection is dead? Maybe click refresh and it will pull the latest data. Can you be more specific?

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[tina345]

Apparantly when I refreshed multiple times, it worked for me.

I guess refresh should reconnect to database.

[tina345 · Accepted solution]

Sometimes when I try to refresh previously opened report , it says connection errors  and tells me you have to reconnect to Oracle.If I close and reopen power BI desktop it reconnects and refresh with latest date.

My confusion here is if I left my session open for 6-7 hrs and data base is disconnnected, is there a way to reconnect without closing power BI desktop?

Refresh sometimes won't make connection for me.