Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered
I want to update tables in an Oracle database in an on-premise or Azure environment from Fabric Datawarehouse.
Is it possible to update external data via a private network?
Could you please tell me about the necessary components?
thank you
Solved! Go to Solution.
As your Oracle database is in On Prem which would already be within a Vnet/private network, you can set up an on premises data gateway on a server that would act as a bridge between your oracle database and fabric warehouse for transfer/movement of data
Hi @kkoba ,
As a supplement, updating tables in your Oracle database from Fabric Datawarehouse is possible both in your local environment and in your Azure environment.
A data gateway is necessary, which acts as a bridge to securely transfer data between your local Oracle database and Fabric Datawarehouse.
For more details, you can refer to below document:
Set up your Oracle database connection - Microsoft Fabric | Microsoft Learn
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @kkoba ,
As a supplement, updating tables in your Oracle database from Fabric Datawarehouse is possible both in your local environment and in your Azure environment.
A data gateway is necessary, which acts as a bridge to securely transfer data between your local Oracle database and Fabric Datawarehouse.
For more details, you can refer to below document:
Set up your Oracle database connection - Microsoft Fabric | Microsoft Learn
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
As your Oracle database is in On Prem which would already be within a Vnet/private network, you can set up an on premises data gateway on a server that would act as a bridge between your oracle database and fabric warehouse for transfer/movement of data
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Fabric update to learn about new features.