oracle power bi scheduled refresh failing

[vijaykaali811]

we have power bi report connecting manually to oracle database with firewall NAT IP . 

issue is  manual refresh is always successful but scheduled refresh is always failing with  "host or object does not exist" 

is desktop version / web version always different . or web version need to open firewall from web version server ? 

[v-mdharahman]

Hi @vijaykaali811,

Thanks for reaching out to the Microsoft fabric community forum.

It looks like you are facing issue with scheduled refresh which is failing meanwhile manual refresh is working fine. As @Elena_Kalina has already responded to your query, kindly go through her response and check if your issue can be resolved.

I would also take a moment to thank @Elena_Kalina, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.
Community Support Team

[Elena_Kalina]

Hi @vijaykaali811 

The issue you're experiencing (manual refresh works but scheduled refresh fails) typically occurs because:

1. Different network paths: The Power BI service uses different IP addresses than your local machine when performing scheduled refreshes

2. Firewall/NAT configuration: Your Oracle database firewall only allows connections from your specific IP address (your desktop) but not from Power BI cloud service IPs

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

[vijaykaali811]

Thank you for the reply.   it happened in published reports / in cloud .  Manual refresh works but not scheduled refresh.  Cloud power BI manual refresh take local desktop path ? compare to scheduled one ?  

if Scheduled cloud power bi refresh to work, what need to be done  to open Firewall for Cloud IP's  ? 

[Elena_Kalina]

So your manual refresh works but scheduled refresh fails with "host or object does not exist"? Classic issue - let me break it down in simple terms. Manual refresh works because it uses your local IP (already whitelisted in your firewall).  Scheduled refresh fails because Power BI cloud uses Microsoft's servers (IPs not whitelisted)

1. Whitelist Power BI IPs 

1. Grab current Power BI IP ranges from Microsoft's docs

2. Add these to your Oracle firewall/NAT rules

2. Setup a Data Gateway (If you can't whitelist cloud IPs)

1. Install Power BI Gateway on a server inside your network

2. Configure it to access Oracle

3. Route scheduled refreshes through this gateway

Quick Pro Tips:

• If using gateway, verify Oracle client is installed on that machine

• Double-check credentials used for scheduled refresh have proper DB access

Why Manual Refresh in Service Works?

When you click "Refresh" in Power BI Service, it actually routes through your browser (your IP). Scheduled refreshes come directly from Microsoft cloud servers.