cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sowmyar
Frequent Visitor

Pass user for embedded application to power bi report

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?

5 REPLIES 5
V-pazhen-msft
Community Support
Community Support

@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
Super User
Super User

@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.

@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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
!! Subscribe to my youtube Channel !!

@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?

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!