Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am using a multi tenant azure database and I have created one report that i would like to share with more than one person. I have created a parameter to change the schema of the database and it works fine. I want to share this report with users but i want each user to see report based on a different database schema.
I have created a table with users two columns (email, schema) expecting to bind schema to username. But i got stucked and I cannot go on.
Can you help ?
Solved! Go to Solution.
@yiannis , You can a parameterized connection. But I doubt you can do that with help from RLS
https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
I have tried RLS but i cannot change the schema parameter. I have created a parameter called [Schema] and I have placed it at the query.
I have also created a table with email and schema columns in order to use the Username() and create the role accordingly.
i got stucked after as i dont know how to bind the schema with the username(). I have to mention here that the queries i get data does not have a field with email in order to bind them. So the only way i can figure out is to open a dialog to the user asking his email and then do the binding afterwards. Still i don't know how to do it
Hi yiannis
Did you ever solve this? I'm in the exact same sitation.
Thanks
ARP
@yiannis , You can a parameterized connection. But I doubt you can do that with help from RLS
https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |