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

Diamond Contributor

Jul 17, 2020

amitshah1935

As a comment if you connect using Power Query, Refresh is not supported for it in Excel Online. If that's data model connector you shall do nothing within Excel to connect, adding connection to Enterprise data GW shall be enough.

amitshah1935

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.