Forum Discussion
Add New Users to Gateway Cluster
When they publish a report that uses that source, you will see the Gateway connection available to them under the data settings page as mentioned below. I know it is a little confusing. They will not see a list of all data sources that have been defined, rather Power BI will match what is in their report with what you have defined. Please note that you need to keep the definitions the same (ie. don't use a server alias in one place and a fully qualified name in another, also to be safe, keep the case consistent). Please let me know if this helps!
Dawn
-Justair07,
If you only want them to be able to use the data source that you have defined, you need to add them as users of the data source. This will allow them to publish reports using this data source and schedule refreshes of their data sets. You will do this seperately for each data source and each data source can have a different set of users defined that can use it.
Hope this helps!
Dawn Thompson
PS: If this solution works, please mark it as a solution to help others. Kudos are nice too.
-
dethompson97 I tried that as well but when I added the user at the datasource level, I went over to the Power BI service account of the user I shared it with and I did not see the data source as being available to them to use. Maybe I was looking in the wrong spot.
When they publish a report that uses that source, you will see the Gateway connection available to them under the data settings page as mentioned below. I know it is a little confusing. They will not see a list of all data sources that have been defined, rather Power BI will match what is in their report with what you have defined. Please note that you need to keep the definitions the same (ie. don't use a server alias in one place and a fully qualified name in another, also to be safe, keep the case consistent). Please let me know if this helps!
Dawn
dethompson97 Thank you!! That was the step I was missing! I needed to look at the published reports Dataset settings for the user I shared the datasource with and it was staring me right in the face under Gateway connection
- Hi there
You have to go into the App Workspace, then Settings, then Datasets.
Finally click on the Dataset and look under Gateway Connection Please follow the below setps.
Path:- select the workspace>> double click >> data set >> select the dataset >> settings >> Gateway Connection.
Please refer the below snippet.
If you have any queries, please let us know.
If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?BR
venal.
dethompson97 Hello, thank you for advise. Indeed added user can see shared data source
But can't refresh data. Manual or planned refresh failed:As soon as i add this user also as a gateway Administartor refreshes start to work.
What can be a reason?
Thank you.
Can you give us some details about the type of data source this is? The message isn't super clear and I can't tell from what you have blacked out. Perhaps that will spark some ideas in the group.
Thanks!
Dawn
This data source uses custom data connector on on-premises data gateway with OAuth2 authentication.
