Forum Discussion

vmsouza30's avatar
vmsouza30
Helper I
9 years ago

DAX FUNCTION

I have a table with the name of 10 clients, where I want to demonstrate multiple sales reports.   In this project I need to limit the display of data to only the client who will see their own repor...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi vmsouza30

 

Yes Power BI can do this,  The feature you are looking for is Row Level Security (or RLS)

 

Here is a good blog to get you started, otherwise just search for Power BI and RLS

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/

 

The other decision you need to make is around letting your clients log into your tenant, or if you provide the data via Power BI embedded.

 

Is that helpful?

 

 

  • vmsouza30's avatar
    vmsouza30
    Helper I
    9 years ago

    Hi Phil,

     

    I have already applied the RLS to restrict access to data only for a specific client (MOBILE).

     

    After that, that's my problem starts, I need to have a dashboard (I need applied Graphic Scatter) where I can show comparative data with other clients.

     

    Example: The customer who buys 100 items from a product at that time, I want to compare and show the customer, for this segment, whether I have more purchases or fewer products.

     

    As a general rule, I have to hide the names of the other Dashboard clients.

     

    It´s clear?