Forum Discussion
Help!! - Having trouble adding a SharePoint Excel to an On-Premises Data Gateway
Anonymous,
Please mark appropriate replies as solutions to close this thread if your issue is solved. That way, other community members would easily find the answer when they get same issues.
Regards,
Lydia
Anonymous,
1) I mean On-premises gateway(personal mode), this gateway us able to refresh your dataset when you combine online data source and on-premises data source in a single dataset.
2) ODBC connection based on Windows authentication is currently not supported. If you use other type authentication in your ODBC source, the On-premises gateway(personal mode) can be used. If you connect to ODBC data source using windows type auth, please split your data sources(Sharepoint online and ODBC) into different datasets, then use on-premises gateway to refresh the dataset that contains ODBC data source. The dataset that contains SharePoint online data source doesn't require gateway to refresh.
3) The two gateway can be installed on same server, ensure that the server is always on and connected to internet, dataset can be refreshed even everyone has gone home. Go to Settings->Datasets and find your dataset, choose on-premises gateway (personal mode) option, after you edit the credential for your data source, you are able to set schedule refresh for the dataset using this type of gateway.
Regards,
Lydia
Thank you Lydia.
Just need some clarification.
An On-Premises Data Gateway can be installed using a single Power BI Service account (i.e. UserA) and that same On-Premises Data Gateway can be shared with other Power BI Service accounts (i.e. UserB). It can be shared by making UserB as Administrator for the Gateway and you can provide UserB with permissions for the added datasource(s) too. This means that both UserA and UserB, from within their own Power BI Service accounts can schedule the data refreshs and configure the Gateway.
With a On-Premises - 'Personal' Data Gateway, only the Power BI Service account that installs the Personal Gateway can use that Gateway. For example, if UserA downloads and installs the Personal Gateway then only UserA can use the Personal Gateway. UserA cannot share the access/privileges for the Personal Gateway with another user.
Are both of my statements correct?
Thanks.
Anonymous,
Yes. Your statements are correct.
Regards,Thanks for your help on this.
Anonymous,
Please mark appropriate replies as solutions to close this thread if your issue is solved. That way, other community members would easily find the answer when they get same issues.
Regards,
Lydia