JWT token generation and filter the data as per the username logged

[Anonymous]

Hi All,

I have a scenario where i need to generate the JWT token in power BI with the username logged into Power BI acccount and then call an API with this token to get data.

Based on the username logged into Power BI which is sent via JWT, We need to filter the data.

Could you please suggest a way to do this and also the code used for the same?

Thanks in Advance:

Nishanth

[v-frfei-msft]

Hi @Anonymous ,

Did you mean Row-level security (RLS) with Power BI? Please refer to the online document.

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

[Anonymous]

Hi @v-frfei-msft 

No, Am not looking into RLS for now.

In power BI, I need to generate the App token which has username details encoded in it. When a Single API with this token is called we will receive the data based on the username in the set token. Please specify a way to do this.

I tried Running R script in "Get Data" option then generated the token. But issue i found is i cant pass the value of userprinciplename() i,e logged in user of power BI to R script.

Thank you:

Nishanth