Gateway Security

hespinoza · ‎06-29-2020

Good morning Power BI users,

I'm in need of understanding the security for the Gateways. We have setup a Gateway on one of our utility servers. There are just two employees that have access to this gateway, myself and one of our Network guys. I'm able to refresh our dataset on schedule since I do have access to the gateway. However, we have a third employee that is in charge to push new datasets and report and he would like to also setup data refresh schedules on his datasets. However, it looks like the only way for him to a have access to the gateway is to give him Administrative access tot he gateway. Is this correct or am I missing another setting somewhere? Thank you all.

v-alq-msft · ‎06-29-2020

Hi, @hespinoza

I'd like to suggest you add the user to a data source. After you add a data source to a gateway, you give users and email-enabled security groups access to the specific data source (not the entire gateway). The data source users list controls only who is allowed to publish reports that include data from the data source.

Add users to a data source

In the upper-right corner of the Power BI service, select the gear icon 'More options'=> Manage gateways.
Select the data source where you want to add users.
Select Users, and enter a user from your organization who you want to grant access to the selected data source. For example, in the following screen, you add Maggie and Adam.

4. Select Add, and the added member's name shows up in the box.

Remember that you need to add users to each data source that you want to grant access to. Each data source has a separate list of users. Add users to each data source separately.

For further information, please refer to the document .

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎06-29-2020

Hi @hespinoza,

Yes, you are right! Third user require administator access on gateway.

Check below link for more details:

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-manage#manage-users-and-ad...

hespinoza · ‎06-29-2020

Would having access to the dataset not be enough for the user to see the datasets/gateway? Is the only way to let the user use these data sources be having admin access to the gateway?