Forum Discussion
gateway connection
xpfc,
Some data source (Excel file) is supported to refresh by using both personal gateway and on-premises gateway. Some data source source is supported to refresh by using only on-premises gateway. Please refer to "Do I need a gateway" section on the link below:
And "List of available data source types" section on the link below:
On-premises data gateway
Which gateway should I used? It depends on your requirement. On-premises data gateway can be used by Power BI, PowerApps, Flow or Logic Apps and it can be shared and reused by multiple users. In Power BI, the on-premises gateway can be used for both schedule refresh and DirectQuery.
However, personal gateway is only for Power BI and can be used as an individual, it is used for on-demand refresh and schedule refresh.
Regards,
Charlie Liao
Thanks for your reply
The schedule refresh seems to work with either option, which is what I need so I guess it doesn't really make much difference which gateway I am using.
Just for more info:
The first screen shot is just an odbc connection and gives me both options.
The second screen shot is taken from a dataset which has Excel and odbc connections, and I only get the Personal Option, where as you say below excel can use both.
The gateway was installed as an "On premise data gateway" on my server.
Thanks