Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

One report for multiple users

Hello,   I have one requirment when I need to crate one report and that report will be shared across 10 usres but the report should show only the user specific data i.e. if user1 logged in to power...
Show and Tell
  • MFelix's avatar
    MFelix
    8 years ago

    Hi Anonymous,

     

    I believe that the best way is to use the Row Level Security check this link with explanations or just google: Power Bi Row Level Security.

     

    Regards,

    MFelix

  • MFelix's avatar
    MFelix
    8 years ago

    Hi Anonymous,

     

    Below see the notation for AND and OR filter:

     

    AND notation

Calculate (Sum([Value], [Category] = "BLD" && [Category] = "BMV")

OR notation

Calculate (Sum([Value], [Category] = "BLD" || [Category] = "BMV")

    I have made it inside a calculate just for better understanding.

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
8 years ago

Hi Anonymous,

 

I believe that the best way is to use the Row Level Security check this link with explanations or just google: Power Bi Row Level Security.

 

Regards,

MFelix

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks MFelix.

 

The link is really helpful. I should have googled it before posting question here though :). Thanks for your time.

 

Regards

Harshad