Forum Discussion

srbh93's avatar
srbh93
New Member
2 years ago

Dynamically switching Snowflake schema based on user login without using RLS

There is data stored for different clients in different schemas within a Snowflake database. How do I change the schema connected to the Power BI report depending on the logged in user.There is a table in the Snowflake database that associates users with their respective schemas.I am aware there is userprincipal name available in DAX query but is there a way to acheive this in Power query and not to use RLS? 
Kindly help me out with this issue. 

Need Help
Show and Tell
Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi srbh93 ,

    Your requirement can be interpreted as the need to dynamically obtain user information to change the data source. But whether it's Power BI or Power Query, there's no way for the data source to be dynamic.


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