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?