Dynamically schema switching for the user logged in power pages and Render the reports from power Bi

[Kr97]

Hello ,

whenever the Ever the user log in the portal(webpage/power apps) Dynamically the schema has to be selected according to the user from the Snowflake Schema and only that schema data should be rendered on the power Bi Dashboard. 

I am trying to validate the user using Azure B2C and from the whenever the user logins i am able to store the Usename in the data but unable send that particular username to power Query(power Bi) for the schema dedicated to that user. If any leads are there regarding this highly appreciated. Thanks 

[PrismaBI]

Hi! I need that too. To automatically switch a parameter in the string connection (Power Query) based on the logged in user. How did you come to a solution?

[lbendlin · Accepted solution]

That should work as long as your Power BI data source is in Direct Query Mode, you use Dynamic Query Parameters, you produce the same output structure across schemas and RLS on the schema columns.

Easy? No.  But doable.