Dynamically switching Snowflake schema based on user login without using RLS

[srbh93]

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. 

[Anonymous]

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.