Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Power BI snowflake connector overwrites datasource with same datawarehouse

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.

Data Protection
Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
    v-yinliw-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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.