Pass user for embedded application to power bi report

[sowmyar]

I have a scenario in which the power bi report will be embedded in another application,In that case I have a date slicers selection outside the power bi report in the embedded application.Can that date selection be passed to my power BI report?

[ssalaskar]

Did anyone found solution? I am facing same problem

[V-pazhen-msft]

@sowmyar 

Power bi report cannot be filter with any date outside the report itself. I am afraid you would need to add a date slicer or filter in the power bi report, you even need to setup an appropriate relationship if the date column is not in the same table. 

Best regards
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@sowmyar , for pro users, using as embedded using URL, you can refer

https://docs.microsoft.com/en-us/power-bi/service-url-filters

are you using embedded power bi ?

refer

https://community.powerbi.com/t5/Service/Pass-Parameter-in-Power-BI-embedded-Report/m-p/853488

https://www.youtube.com/watch?v=yNF-_l2f7w0&feature=youtu.be

[sowmyar]

@amitchandak  yes we are using power bi embedded, so we can pass filter parameters.

for username I can provide username() in power bi,for date fields what should be done at the power bi end.

[amitchandak]

@sowmyar , You can pass your choice of username(which can be based on portal login) , and then you will get that information in userprincipalname(), unlike normal power bi where it is email, it can be anything.

Now use this in power roles (for RLS) to secure your data based on user

[sowmyar]

@amitchandak ya that is for the user other than the user information i need to pass the date range what the user is selecting,how to pass that to power bi?