Forum Discussion
Binding Database schema to report
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