Updating Power BI Web Data source Bearer Token via power BI SDK

[nasirali]

I have created a power BI report with web datasource, which is getting data from my Web Api using bearer token. I have hard coded the api token inside header. Also I have embedded the report inside my Asp.net MVC project using power BI SDK. Everything is working fine. 

But i want to make my report dynamic, in the sense that i want to change the bearer token according to logged in user. So my question is: Is it possible to change the Web Datasource authentication token via Power BI SDK. As i want to pass my logged in user's token to report. so that the user sees only his data. Or how can i achieve something similar to that? Thanks.

[v-sihou-msft]

@nasirali

In Power BI, it's not possible to dynamically populating the current login user bearer token in Power BI Embedded. To have each user see their own data, you just need to configure Row Level Security. You can apply row level filter with USERNAME() function. For more details, please refer to tutorials below:

Dynamic Row Level Security with Power BI Made Simple

Power BI – Dynamic Row Level Security – Tips to get it working!

Row Level Security In Power BI

Regards,

[nasirali · Accepted solution]

Thanks for reply. I read the link you suggested. I want to, sort of, acheive that. I am new to Power BI but from the links it is seems like Row level security works with Power BI users. Am i right?

I am developing an application where App Owns Data. Report is embedded inside MVC application and data for the report is coming from Web Api and i want to retrieve data based on user who is logged inside MVC application. Can we some how use that user info?

The only other way i have found so far is to pass user related data inside Filters using powerbi.embed configuration. Any comments will be highly appreciated?

Regards