PowerApps Power BI Integration Dynamic Filtering

In this video, you will learn about PowerApps Power BI Integration Dynamic filitering. You know that cool concept where you can use the Power BI Tile in PowerApps to show a Power BI report and filter the data based on what you are seeing in PowerApps. Pretty cool.

Link to Power BI Documentation

[jessicarodrigues]

For who are using the "pin" to create various Tiles doesnt work if you just change the URL. Theres a option in the PowerApps BI Tile named "AllowNewAPI", set to TRUE and worked fine for me"

[pedroeaugusto]

As we say in Brazil, "You are BRABO"! (Like you are the best, but cooler). Thank you so much Shane for all the lessons you give us!

[DylSimons]

Hi Shane, PowerBI controls in Power Apps now have a new property "AllowNewAPI", set that to true and it works as expected. It defaults to false, which turns this dynamic filtering feature off

[robertmerritt]

Awesome, as usual Shane! Suggest increasing size of button, making it transparent and layering it over the PowerBI control.

[DataSpinners]

Great vid Shane - it's soo important to use these techniques to pull together the Power Platform!

[nathanface]

Yes, yes, yes! I was just trying to figure out how to do this yesterday!!! Thank you!

[danilom]

You rock dude! You’re the best! Thanks for make my corporate life better! Greetings from Brazil

[fidelixwashington]

Awesome video Shane, as always!

I would like to know if it is possible to determine the first page the user will see using URL query parameters?

[AndreasMake]

You have a great day too for sharing. Thanks Shane for your awesome videos.

[LuxiaShen]

Hi Shane, what should the "Slider1.Value" part be for a text input filter? Thanks!

[gemmaparker]

Thanks so much! Love this and can use it when my data source doesn't have spaces, but when my table and columns have spaces in them, how can I manage this in the TitleURL? Thanks!

[giannibergamo]

Hi Shane, great video! In my case I only managed to make the button work. I don't know why filters doesn't work with the tile... The query string is correct: parameter filter and values are the same that works with the button. The visual is correctly pinned, not a live page.

[matthewvandersteen]

Thanks Shane! This helped me a lot! Keep up the good work.

[sudhamshkadudas]

As always, that was really helpful Shane. The filtering works perfectly fine on the report, but when I try to filter it on the PowerApp, it doesn't seem to work. I am using the following query &filter=Submissions/FY eq 'FY17/18'.
I am pretty sure I have not missed any of your steps having gone through the video multiple times. Are we no longer able to filter through querystring on dashboard? Has anything changed with PowerApps or PowerBI ?

[itXpert]

This is just what I needed. Great video! Great teacher! Thank you.

[devyanisingh]

I had one question, can I choose two values for a single selected filter on the Power Apps to filter the Power BI Tile? Or is that not possible?

[fscohen]

Hi Shane,
Is there any way to apply a filter to the tile with a "contains" condition instead of equal (eq) operator?

[DarrynPinto]

Hi Shane, thank you so much for this video. One question - whenever i embed a power bi tile in powerapps, while in Power Apps (for all users), befoe the tile displays, it asks the used to sign-in to powerbi almost all the time. It's the same microsoft user ID for both. Is there a way to avoid this from happening?

[benaima]

Hi Shane, thanks again for your help. Can I use dynamic filtering to match one of the power bi tile fields with the user logged in my powerapp? I tried the User().email function but could not make it work. Thanks in advance for the reply!

[derek_shannon]

"Just try things" -- Very good advice, Shane! ;-D