cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Robin1988
Helper III
Helper III

Filter embedded Power BI report using the current users loged in name

Hello all,

 

I'm testing power bi embedded in the power portal and made a simple case. But how does it work with the defined roles based on current user. I see a lot on the web but it should be easily be done in the liqued tag right? Can someone help?

He is my tag:

 

{% powerbi authentication_type:"powerbiembedded" path:"https://app.powerbi.com/groups/289995fc-fe4c-4bda-8f13-46e8cb8233a2/reports/5e52eea8-f369-4176-a996-4f5252b024e6/ReportSection"  roles:"Dynamic RLS" %}</div>

 

Here is the role i defind in the power bi report.

Robin1988_0-1651647654437.png

 

 

2 REPLIES 2
OOlashyn
Super User
Super User

Hi @Robin1988 ,

You correctly passed the role from the portal to the Power BI. But I am not sure what exactly you are trying to achieve here. Can you explain in more detail? Regarding your DAX expression - as far as I recall USERPRINCIPALNAME when report is viewed by the portal user should return its email.

----------------------------------------------------
If you find this post helpful consider marking it as a solution to help others find it.
Robin1988
Helper III
Helper III

Hello @OOlashyn thx for your reply!

I was hoping to see this in the portal, when I'm activating the view with the role RLS:

Robin1988_0-1651734848084.png

 

But in the portal it's not even loading:

Robin1988_2-1651735034802.png

 

 

So I was wondering did I miss something in the liquid tag? Or an other setting to make this work..

 

Have a nice day sir!

 

Helpful resources

Announcements
May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel News & Announcements 768460.png

What's New in the Community?

Check out the latest News & Events in the community!

MPP IDEAS updated 768x460.png

Ideas

Discover ideas and concepts from users like you for how to use Power Pages and take your work to the next level.

Top Solution Authors
Users online (1,367)