Forum Discussion
Distribute to large audience
Super UserHi grangema
Why not just use Row Level Security and based on the logged in user they will just see the warehouse associated to their data?
This will save you a lot of time and effort and only need to maintain one report
here are details how to create RLS: Power BI Desktop Dynamic security cheat sheet - Kasper On BI
Hi GilbertQ,
Thanks for your answer.
I know how RLS is working, i'm already using it inside this model to manage a part of the security.
Your option would be a good one if we were allowed to mix data between our different clients. And the volumetry is also huge for each datawarehouse, making me do that split by report for better performance in addition to the import part with my composite model.
Do you have any other idea ?
I didn't mention it, but my source is BigQuery and native query is not available yet (planned for September).
Thank you,