Forum Discussion

Marcel1989's avatar
Marcel1989
Frequent Visitor
3 years ago

Connection between Power BI <- Gateway <- Oracle Database

Hello,   in our company our data is in an Oracle database. In order for users to get access, they need to connect to a gateway that is interposed.   I have already put the gateway in the settings...
Need Help
Thejeswar's avatar
Thejeswar
Super User
3 years ago

Hi Marcel1989 ,

Did you try Getting Data using Oracle Database Connection? You would require a Oracle Client installed in the machine to use this. Check it out!

 

 

 

Marcel1989's avatar
Marcel1989
Frequent Visitor
3 years ago

The administrator told me not to do that because I am supposed to connect to the gateway and not to the Oracle database. Is this still the right way? Then I would try again with the administrator this possibility.

  • Thejeswar's avatar
    Thejeswar
    Super User
    3 years ago

    Hi Marcel1989 ,

    Adding Datasource to a Gateway is helpful when you want to perform a Schedule refresh of your reports. Even to build a report directly in Power BI service you would need a Published Dataset which requires it to be created in Power BI Desktop.

    Per my understanding, to connect from Power BI Desktop, the only way to get data is as I shown above

     

    For your reference, the Below link speaks in detail about the Datasource in Gateway

    Add or remove a gateway data source - Power BI | Microsoft Learn