I have a gateway setup to internal databases with my account. I have used the Manage Gateways and Set some people as Administrators. When someone besides me publishes, when they go to the Gateway, it wants to setup the connection, although the conenction is already setup. I have Allow user;s cloud data sources to refresh through this gateway cluster also. I have to Take Over data source and it automatically connects to the gateway. I don't want to have to setup each new report thats published.
Solved! Go to Solution.
I am not very sure about your requirement. When you add other members as administrators in the gateway, other members will see all the data sources which you have added within the gateway.
When other members publish the reports to Power BI Service which use existing data sources in the gateway, they don't need to add data source again within the gateway.
Here are some screen shots. I noticed the data source casing is slightly different. Maybe it thinks its different a different source. If you try to create it, it tesll you there is already a source
We face same problem. New gateway administrators (recently added) cannot configure dataset. This is what I see when I'm configuring gateway for dataset:
but, my colleagues who were recently added as gateway administrators see it like this:
So my guess new admins are not processed correcly in service:
Are you MS guys aware of this?
Thanks blynn for good advice.
This worked. Until now I was not aware of "Data Source Users" . Now when I take a look, all datasources have old gateway admins as users but not those new ones. Maybe that is what changed? After some service update, new admins are not added to datasource users by default?
Anyway, thank you.
I don't know. It would seem to me, if they are Gateways Admins, they could use any data sources. Its like MS added a nother layer of security, but if thats the case, they shouldn't be separated. If they can publish reports to the workspace and the reports use current data sources, they should get permission to data sources. Maybe there are cases where they are an admin, but they can't access Financial info, but other info.
The easiest method would be if they are added as an admin, alteast a notification they will need to be individually given access to the data.
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Mark your calendars and join us for our next Power BI Dev Camp!