Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Different report by logged in user

I am new to PowerBI and I have a project where I store my data on MySQL( or I will use MSSQL) server. Each user has a defined ID. Is it possible to create a user login or something like that that wo...
Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, Anonymous 

    When you created the RLS in your Power BI dataset and set it up for the users who are going to open the report. Their accounts that are used to log in to the Power BI are the credentials required by RLS (Username and user principal name). They can access their report screen to see their restricted data as soon as the RLS started to take effect.

    Therefore, you don’t have to create another username with a password for your users. Their Microsoft account (Username and user principal name) can be the basis for the effect of RLS.

    How to create and use RLS in Power BI

    Restrict data access with row-level security (RLS) for Power BI Desktop

    Using the username() or userprincipalname() DAX function

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-robertq-msft's avatar
v-robertq-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Anonymous 

When you created the RLS in your Power BI dataset and set it up for the users who are going to open the report. Their accounts that are used to log in to the Power BI are the credentials required by RLS (Username and user principal name). They can access their report screen to see their restricted data as soon as the RLS started to take effect.

Therefore, you don’t have to create another username with a password for your users. Their Microsoft account (Username and user principal name) can be the basis for the effect of RLS.

How to create and use RLS in Power BI

Restrict data access with row-level security (RLS) for Power BI Desktop

Using the username() or userprincipalname() DAX function

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    If I understand correctly. It means, that when I assign a user with a Microsoft account and with RLS I will be able to show him a specific report with his unique data? 

    • v-robertq-msft's avatar
      v-robertq-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi, Anonymous 

      Yes, this is roughly what I want to let you understand. To show the end-user a specific report with his unique data, you should also go to the “Security option” of the dataset that has RLS to assign them their corresponding created in Power BI desktop, like this:

       

       

       

      Best Regards,

      Community Support Team _Robert Qin

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.