Power BI snowflake connector overwrites datasource with same datawarehouse

[Anonymous]

I have  different reports connecting to snowflake datawarehouse with different usernames and roles. whenever I publish a report it replaces the datasource created by the previous report.

What I learnt is that the datasource is identified by hostname and warehouse name and its common to all reports having same datawarehouse. From "manage connections & gateways" menu I can see only one datasource is created for these reports.

In snowflake datawarehouse is virtual compute resource which can operate on multiple databases and many users can share the datawarehouse. Its not practical to have individual datawarehouse to each user when there are multiple users having different level of data acess and want to create reports.

is there any solution to this limitation?

Note : we want to use directquery mode always.

[Anonymous]

I have different reports connecting to snowflake datawarehouse with different usernames and roles. whenever I publish a report it replaces the datasource created by the previous report.

What I learnt is that the datasource is identified by hostname and warehouse name and its common to all reports having same datawarehouse. From "manage connections & gateways" menu I can see only one datasource is created for these reports.

In snowflake datawarehouse is virtual compute resource which can operate on multiple databases and many users can share the datawarehouse. Its not practical to have individual datawarehouse to each user when there are multiple users having different level of data acess and want to create reports.

is there any solution to this limitation?

[v-yinliw-msft]

Hi @Anonymous ,

Could you please explain to me more about your question?

I 'm not sure what limitation you want to solve.

Best Regards,

Community Support Team _Yinliw

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

[Anonymous]

@v-yinliw-msft - Thanks for quick reply. here is my explanation.

Suppose I have 2 different reports say R1 and R2 both are using snowflake connector to get data from Snowflake database.

Intially I published report R1 with WH1 as warehouse, U1 as username and Role1 as the role. It created a datasource in Power BI service as shown below
{"extensionDataSourceKind":"Snowflake","extensionDataSourcePath":"host.snowflakecomputing.com;WH1"}

Now If I publish report R2 with WH1 as warehouse, U2 as username and role2 as role. if you notice this is the different report having same warehouse but different username and role but still it updates the same datasource in PBI service, due to which it impacts the report R1 which stops working as U2 & role2 are not suitable for report R1.

We have many users/Roles to create reports with different access levels. With the help of roles we have more granularity of access control, not only rows of the tables but we also have restrictions on tables as well.

In short if we have common warehouse for multiple users we cannot have reports with different users/roles, Also its impractical to create so many warehouses per user/role.

It seems bug to me and there is already an idea posted but its not taken into consideration yet : https://ideas.powerbi.com/ideas/idea/?ideaid=d5cb7757-80cb-ec11-bea1-281878bd52ac

I wanted to know is there any work around available or any mechanism to expedite resolution of above bug.