Forum Discussion
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...
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.
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