Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
buchta
Frequent Visitor

dynamic query string parameters

Hi guys 

 

I am looking for help with the following challenge. 

 

I am embedding PBI dashboard tile into Power Apps I would like to apply default filter when the user opens the PBI tile in the power app. 
I found this 
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters
but I am looking for a more dynamic solution where I could use DAX function USERPRINCIPALNAME(). 

what I want to achieve is that once the user opens the app by default his name would be filtered. 
It is not RLS because I want the user to have access to all the data but I would like to have a default filter when the PBI tile is opened in power apps. 

Some kind of dynamic bookmark based on the USERNAME() or USERPRINCIPALNAME() funtions

 

THank you for your help 

 



1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @buchta ,

This is the related document, you can view this content:

https://www.matthewdevaney.com/interactive-charts-reports-with-power-bi-tiles-in-power-apps/

https://microsoft-bitools.blogspot.com/2020/03/embed-power-bi-tile-in-power-apps-with.html

https://community.powerbi.com/t5/Desktop/Is-it-possible-to-have-a-query-string-with-dynamic-paramete...

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
buchta
Frequent Visitor

@v-yangliu-msft thank you indeed valuable links.. i might come back to search more on the dynamic filters because I need exactly that what was shown.. tile which can be filtered by the filters used in the app ... but i need 3+ filters and

 

also would like to apply some logic that would open the data for the user who opens the app.. if yo have some links for that I am all eyes ..

 

thank you again.. 

v-yangliu-msft
Community Support
Community Support

Hi  @buchta ,

This is the related document, you can view this content:

https://www.matthewdevaney.com/interactive-charts-reports-with-power-bi-tiles-in-power-apps/

https://microsoft-bitools.blogspot.com/2020/03/embed-power-bi-tile-in-power-apps-with.html

https://community.powerbi.com/t5/Desktop/Is-it-possible-to-have-a-query-string-with-dynamic-paramete...

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.