Forum Discussion
Data Source setup on Enterprise Gateway
Anonymous wrote:
Hello PowerBIs, I have been give the responsibility of maintaining the On Premise Gateway. Part of the responsibility is adding Data Sources. I am struggling on how to setup database/source connections on the enterprise gateway. Multiple users have dashboards built using the same database with their own level of access.
I thought I have to create one connection for each of the user connecting to the same database with their own credentials.(not possible complaints - Duplicate Data Source )
which leaves me with only option
Create one connection with full read access on the database and let all the dashboards from all users refresh using that one connection.
@This leads to my question - how is the source Database/file security handled? @source? @users level access?
My concern is - will there be any security risk to have Data source connections with 100% access to the source.
Appreciate any suggestions or links that can help.
Thanks
Anonymous
Based on my test, it is not allowed to set up different credentials for one data source in one on-premises gateway. You can either
- Set up multiple on-premises gates and create datasource with different credential in each.
- If not in DirectQuery mode, use Personal gateway and set different credential in indivisual datasets.
As to the security risk to have data source connection with 100% access, I'd agree with Anonymous, "Permission levels should be a concern of the report author." For other aspect, per my personal experience, it should be safe. As the credential is encrypted and Power BI just query the database.
Hi,
Have only recently started using PowerBi across our organisation, and I also wanted to create duplicate data sources but utilise different user accounts (to reflect different permission sets). Within our organisation, we looking to offer self service BI but have some control to which data sources should be created to enable this. But equally to have some form of control as to which business teams have access to what data sources and to also tie down permissions to only specific database/table access. So different business teams may have access to the same database, but each have different table access requirements; this would translate to mulitple data sources on the same database but tied to different domain accounts with specific permission sets at the database level.
Like you, i found out PowerBi's limitation when creating duplicate data sources. However, upon further investigations it would appear that there is a way around it (a hack). You can create multiple hostnames which map to the same target database server.... this potentially allows you to define muitple data sources which effectively relate to the same server. You must ensure that the defined hostname alias is used in the pbix file and publish the content; and ensure that the same matching hostname alias is defined in your gateway datasource. By doing this, you can effectively have mutliple duplicate datasources (i..e same database but different credentials) by utilising hostname aliases. The option could be achieved by dns's or just define local hostname aliases. A hack but appears to work....
Cheers, Hung