Forum Discussion

iqb's avatar
iqb
Helper III
3 years ago

Get User Role in Power Query Editor

Let's I have created 3 roles using role level security.

1) Admin

2) Employee

3) Employer

 

Now I have a power m query(direct query) as below  (right click > advance editor).

 

let
    SomVar = SomeValue,
    Source = .....
in
    Source

 

How can I get user role who is viewing the report/dashboard? I mean I need to know whether the user who is viewing is Admin or Employee or Employer?