Forum Discussion
Multi Tenancy in Power Bi Desktop
danishalam In powerbi service you can use Row Level Security to restrict users to see limited data but you cannot restrict users in power bi desktop to only access certain data to create visualisation. For that you need to implement RLS in source (SQL Server) for each user (who will access data from sql server with their own id). That way user creating visuals in power bi desktop will only be able to import data from sql server based on their access.
danishalam In powerbi service you can use Row Level Security to restrict users to see limited data but you cannot restrict users in power bi desktop to only access certain data to create visualisation. For that you need to implement RLS in source (SQL Server) for each user (who will access data from sql server with their own id). That way user creating visuals in power bi desktop will only be able to import data from sql server based on their access.
Thank you @AnkitPatira for you prompt reply. This Helps.
Does this mean that data is always imported into power BI service?.
Can I use powerBI service to connect to my DB directly instead of it importing the data?.
