Apply multiple filters to Power BI tile

[yperez]

I created a Power BI report and pinned a visual to a Dashboard which I am using in a Power Apps.
I am now trying to apply multiple filters on the TileUrl property of the Power BI tile in Power Apps.
Before doing this in Power Apps, I tested in the report URL by appending the filters shown below and it worked.
When I append the same filters to the TileUrl in PowerApps, it doesn't work, but if I do only one of the two filters at a time, then it works.
Seems I cannot get the two filters to work at a time.
&filter=ContractEntry/EffectiveDateNumber eq '20210518' and ContractEntry/IRHedgeITEMNumber eq 'OAK6055300'

Can this be done in Power Apps? If so, any suggestion on what I may be missing.
@RezaDorrani @ShaneYoung 
Thank you.

[RezaDorrani]

Hi @yperez 

I have not tried with with multiple filters.

Check this article (may be it may help) - Updating the PowerBI Control inside a PowerApps ap... - Power Platform Community (microsoft.com)

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

[yperez]

Thanks @RezaDorrani . I will keep looking into this.

[DWieb]

Hi @yperez . I am running into the same problem. Have you been able to find a solution to this?

[yperez]

Hi @Anonymous, if I remember correctly, I couldn't pass multiple filters into a dashboard, however, I could pass it to the report. So what I ended up doing was creating a tab on the report which will only show the value I needed to display in the Power Apps, then I used the link from that page in the report and appended the corresponding formatting for adding filters as shown starting on line 3 of the screenshot.
The trick here I guess is that initially, we can only point the Tile URL to a Power BI Dashboard, however you can change the Tile URL to make it point to a page on a report instead, then add the corresponding formatting and filters as from line 3 down.
Hope this helps

[DWieb]

Thanks @yperez ! I have been playing around over the weekend and have the feeling that i am getting close to getting the filters (one at a time) to work in PowerApps. I'll keep on trying but would you know at first glace what could be wrong with mine?

[WilliamFarmer]

Hi @RezaDorrani ,

Love to watch your video's, makes live much easier in PowerApps.

You wrote " I have not tried with with multiple filters".

I've noticed that you've posted a video on which you show how to use multiple filters on a Power BI tile, however if I use that same logic in a Power BI tile in a Gallery, it will return the unfiltered data.

Any suggestions ?

[WilliamFarmer]

In the meantime I've solved it by concatenating the 2 values.... now it even works having a Power BI Tile in a Gallery 

[ArturCosta]

Hi @yperez , how do you get the url parameters? my report page url format looks different to yours. Thanks! 

[yperez]

Hi @ArturCosta , if I remember correctly, I created a tab in the PBI Report with just the visual I wanted to show in the tile. While in the report in the portal go to File > Embed report > Website. From there, you can get the URL in this format below.
https://app.powerbi.com/reportEmbed?reportId=80a93b98-7c05-4ebe-b1fc-3b52ce6f1303&autoAuth=true&ctid...

then you only need to make some additions to the url to show only the specific tab using the &pageName parameter
As far as for filters, you will then add the &$filter section as shown below. One thing you have to remember is that you will need to specify the filtered columns in the format of [table]/[fieldName]. In the example below, my first filter is on the table ContractEntry column EffectiveDateNumber, hence ContractEntry/EffectiveDateNumber.

Hope this helps.

"https://app.powerbi.com/reportEmbed?reportId=80a93b98-7c05-4ebe-b1fc-3b52ce6f1303&autoAuth=false
&pageName=ReportSection70aa1ed6ac6cce4e7c27&ctid=78adacea-5452-4c1d-a049-11159edc6c7f&config=eyJjbHVzdGVyVXJsIjoiaHR0cHM6Ly93YWJpLXVzLW5vcnRoLWNlbnRyYWwtYi1yZWRpcmVjdC5hbmFseXNpcy53aW5kb3dzLm5ldC8ifQ%3D%3D
&$filter=ContractEntry/EffectiveDateNumber eq '" & Text(varEffectiveDateNumber) & "' 
and ContractEntry/IRHedgeITEMNumber eq '" & Text(varSelectedItem.ITEMNMBR) & "' 
and ContractEntry/HedgePeriod in (" & varSelectedPeriod & ") 
and ContractEntry/PricingMixFlag eq 'Feed'&filterPaneEnabled=false&navContentPaneEnabled=false"