Forum Discussion
Want to connect Oracle database (hosted in AWS) with Power BI
hi experts, I am able to connect to Oracle database (hosted in AWS) with Power BI using power BI desktop. Now want to publish to power BI service /workspace. Do i need any gateway or additional ...
amitsankar ,
You can install on-premises gateway on the same machine as your Power BI Desktop, then add Oracle data source within this gateway.
Regards,
Lydia
Thanks Anonymous Lydia.
Can you please tell me which on-prem gateway to use ?
FYI: I have already able to connect to AWS hosted oracle data base from power BI desktop; the issue is when I am trying to publish to power BI services.
amitsankar ,
You can install gateway following the guide in this article:https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem.
And then add Oracle data source as per this article: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-manage-oracle.
Regards,
Lydia