Joshua Wallace on 24 Apr 2020 00:00:25
As System Admin I create Data Sources on Data Gateway and grant users access to use them. Users should be able to user them via Power BI Desktop. Currently there is option to connect to Datasets that are already published but it would be better to allow the users to connect using the data gateway as a Proxy so end users don't have to have creds to connect to data sources. This would also help with connection binding before report is published and more control over creds being shared and reducing number of named users with direct access to source databases.
- Comments (1)
RE: Desktop users Connect to Data Source via gateway
Another option that we have seen other Application do without have to have data pass through the gateway is if the user has permissions to data source the connection string is pulled down locally encrypted. Then as long as the user has direct access to the data source it would connect with the creds the data gateway would use.
In some cases we host databases in an area that does not allow end users direct access to the database to protect it so a proxy service is a better option. (Tiered Application Deployment design where limited access to database tier via firewall rules)