Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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?
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.
User | Count |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |