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

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    Hi   Anonymous,

     

    No problem the forum exists for this :D

     

    Regards,

    MFelix

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Thanks MFelix

       

      Need more help. Do you know how I could use the 'AND' condition while makinh the role? I used following but its not accpeting.

       

      ([Category] = "BLD" and [Category] = "BMV")

       

      I am try to check on google but can't find any help yet. Please advise.

       

      Thanks!

      Harshad

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Sorry got it!

        I used the following

        [Category] = "BMV" && [Category] = "BLD"

        and its validated successfully.

         

        Thanks!