Forum Discussion
amitshah1935
Jul 17, 2020Copper Contributor
Can on-premise gateway be used with excel and excel online?
We want to fetch data into excel from an on-premise Oracle server. On-premise gateway seems to be right tool to enable this. It can be used in Power BI but I don't see any way to define a connection ...
amitshah1935
Jul 20, 2020Copper Contributor
SergeiBaklan - right and I could not find a way to load data from an on-premise gateway into Excel. Let me know if you could guide me.
SergeiBaklan
Jul 20, 2020Diamond Contributor
You do not load data from gateway, you load from on-premises database. You add data source to GW, not to Excel or any other app, like
Perhaps there is some specific for the Oracle, but didn't work with it for about 10 years.