Multi Tenancy in Power Bi Desktop

[danishalam]

I have a use case where i want to restrict certain PowerBi Desktop user to see all data, and want them to create visualization with the restricted data. if not can somebody guide me if there is any workaround for it, my database will be SQL server 2012.

[ankitpatira · Accepted solution]

@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]

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?.