How to filter sales data by access rights defined in Azure SQL?

[Anonymous]

I have "ProjectAccess" table in Azure Server. It has columns "ProjectId", "AzureADEmailAddress".

I have "SalesFact" table with columns "SalesId", "ProjectId", "SalesTime","SalesAmount".

How do limit access for logined user so that he sees only Sales data where he have access rights based on ProjectAccess?

I know how role based security works, but this time access rights are defined in Azure SQL.

We can use Analysies Services Tabular model if needed to meet this requirement?

[quentin_vigne]

Hi @Anonymous

If you have a table with email adress and right given, you can easily add Row Level Security to your report by using YourTable[YourColumn]=USERNAME() and putting it on your access table

Quentin

[Anonymous]

1) I have Azure SQL column = "john.smith@hello.com"

2) I create "ProjectManager" role.

3) YourTable[YourColumn]= "john.smith@hello.com"  WORKED FINE

4) YourTable[YourColumn]=USERNAME()                   RETURN NOTHING

What could be wrong? Only UPN is supported?