Forum Discussion

amitsankar's avatar
amitsankar
Regular Visitor
7 years ago

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 stuffs ? 

 

Any help will be appreciated highly.

Need Help
Show and Tell

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    amitsankar ,

    If you mean that intall Oracle in a AWS server, gateway is required after you publishing PBIX file to Power BI Service if you want to refresh the dataset, you would need to add the Oracle data source within gateway usings same connection strings as that in Power BI Desktop.

    Regards,
    Lydia

    • amitsankar's avatar
      amitsankar
      Regular Visitor
      7 years ago

      Thanks Lydia.

       

      Yes , the oracle databse is hosted in AWS.   Do I need to have specific gateway ?

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I have the exact same issue. I can connect to my database via AWS on Power BI Desktop but when creating a gateway it fails to connect to the database address used in Power BI Desktop.