Forum Discussion

amitshah1935

Copper Contributor

Jul 17, 2020

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

Copper Contributor

Jul 20, 2020

SergeiBaklan wrote:
amitshah1935
If that's data model connector you shall do nothing within Excel to connect, adding connection to Enterprise data GW shall be enough.

SergeiBaklan - II didn't follow what you meant by "Enterprise data GW"? Is it different from https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-onprem? Could you please elaborate how does it help in my requirements?

SergeiBaklan

Diamond Contributor

Jul 20, 2020

amitshah1935

Sorry, old terminology. Enterprise data GW is called now On-premises data gateway, and Personal data GW - On-premises data gateway(personal mode).

amitshah1935
Copper Contributor
Jul 20, 2020
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
  Diamond Contributor
  Jul 20, 2020
  amitshah1935
  
  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.