Forum Discussion

akj2784's avatar
akj2784
Icon for Post Partisan rankPost Partisan
8 years ago

Data level security on Power BI

Hi All,   I have data as below .     When Akash logs in, the dashboard should default to Pm Code = 1234, when Ajay logs in, it should default to Pm Code =3234 And it should not prompt user ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

akj2784as I have already said, the username in Power BI is the Microsoft username, which generally takes the form of the user's email address in Office 365 but may be slightly different depending on your organization's specific setup. You need to add a column to this table with those usernames and use those.

akj2784's avatar
akj2784
Icon for Post Partisan rankPost Partisan
8 years ago

ok. Lets assume I have this column in the table. 

So for each user I have PM Code tagged to it in the table. 

 

And I want to equate this PM Code fetched for each user to the Actual project table which has PM Code in it so that it just shows his Projects.

 

Would you be able to guide me with the steps .?

 

Thanks for your help.

 

Regards,

Akash