Forum Discussion
Richard76
7 years agoHelper II
Refreshing live data
Hi folks I'm looking some advice. Designing a machine capacity plan on Power BI linking directly to SQL . Report will have 4 end users 2 of which will need the capability to automatically refresh the...
- 7 years ago
Hi Richard76 ,
In order to have other users to get use of the on premises gateway, in order to update their own data, the following should be done:
- Checking connections for the Gateway under Power BI service-Gear->Manage GateWays (under your Browser, once installed, the gateway would show up as connected);
- Add the User’s Database or Data sources as a datasource under your configured gateway through Power BI service;
- Add the User to the User list, in order to use the data source to create or update report;
- Optional, you could also add that user as the gateway admin, which would allow him to manage gateway settings;
For more details, please check the online document.
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-sql/
v-frfei-msft
7 years agoCommunity Support
Hi Richard76 ,
In order to have other users to get use of the on premises gateway, in order to update their own data, the following should be done:
- Checking connections for the Gateway under Power BI service-Gear->Manage GateWays (under your Browser, once installed, the gateway would show up as connected);
- Add the User’s Database or Data sources as a datasource under your configured gateway through Power BI service;
- Add the User to the User list, in order to use the data source to create or update report;
- Optional, you could also add that user as the gateway admin, which would allow him to manage gateway settings;
For more details, please check the online document.
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-sql/