web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Passing a Concatenated...
Power Apps
Unanswered

Passing a Concatenated String of IDs as Filter Parameters to an Embedded Power BI Report

(0) ShareShare
ReportReport
Posted on by 171

 

Hello Power Apps Community,

I have a Power Apps application that includes a Power BI report, embedded using a URL. I want to apply a dynamic filter to this report based on a variable in my Power Apps application.

Currently, I am setting a variable named varMyValues when a user clicks a button. This variable is a string of concatenated IDs from a Gallery:

Set( varMyValues, Concat( Gallery1.AllItems, ID & ";") )
My Power BI Embed URL looks like this:
"PowerBIUrl&actionBarEnabled=false&navContentPaneEnabled=false"

My goal is to dynamically filter the Power BI report based on the varMyValues variable, displaying only the items with IDs that match those within the variable.

I'm unsure how to modify the Power BI Embed URL to include the filter parameters derived from varMyValues. Is there a way to accomplish this within Power Apps?

Any guidance or suggestions would be greatly appreciated. Thank you in advance!

Regards
Angela

@WarrenBelz @iAm_ManCat @LaurensM @Amik  @madlad 

Categories:
I have the same question (0)
  • iAm_ManCat Profile Picture
    18,256 Most Valuable Professional on at

    Heya,

     

    There's a video you can watch here that will explain how to pass filter choices through to a Power Apps embedded Power BI:

    https://youtu.be/HlLK1IEIMJQ

     

    Cheers,

    Sancho

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 342 Most Valuable Professional

#2
11manish Profile Picture

11manish 234

#3
Valantis Profile Picture

Valantis 187

Last 30 days Overall leaderboard