Powerbi tile filter not working

Like (0) Share

Report

Posted on 25 Mar 2021 14:57:44 by SanderHBI

I'm trying to filter a Power BI tile in Powerapps.

After several trials and many reading I figured it our in my browers it looks like this:

&filter=PowerApp_Belichting_Basislijn/BedrijfLocatieId%20eq%204

However, I cannot get it to work on PowerApps

I tried these ones

&filter=PowerApp_Belichting_Basislijn/BedrijfLocatieId eq '4'"

&filter=PowerApp_Belichting_Basislijn/BedrijfLocatieId%20eq%20%4"

&filter=PowerApp_Belichting_Basislijn/BedrijfLocatieId eq 4"

and many other variations.

I read something about pinning the visual the correct way. I tried to Pin the report and to Pin the visual.

Can anyone help and tell me the right way to define the correct filter URL?

All responses (8)

Answers (1)

TJacobson 2 on 18 Oct 2022 at 08:23:03

Like (0)

Report

Re: Powerbi tile filter not working

Just FYI that setting Allow New Api to "True" for me also worked. I believe that this is contrary to Microsoft's documentation!
Sascha1979 4 on 11 Aug 2021 at 06:58:54

Like (0)

Report

Re: Powerbi tile filter not working

Thanks, this worked. Solution accepted.
AlanChai 2 on 10 Aug 2021 at 22:55:44

Like (0)

Report

Re: Powerbi tile filter not working

Make sure you have set "AllowNewAPI" to true

If this post helps, then please consider Accept it as the solution to help the other members find it.
Sascha1979 4 on 10 Aug 2021 at 20:29:00

Like (0)

Report

Re: Powerbi tile filter not working

Hi there, I am still struggling with the Filtering in Power Apps. The dynamic filter used to work and stopped working at some point in June. The filter criteria is properly setup as a String.

In Powerapps, I am using a Power BI Tile to open a Report Tile:
TileUrl="https://app.powerbi.com/reportEmbed?reportId=<...>&autoAuth=true&ctid=<...>&pageName=ReportSection2dab4418ac0c00e36368&filterPaneEnabled=false&navContentPaneEnabled=false&" &"$filter=Fact_DemCapAct/DemandID eq '"& LastItem.ID&"'"
The result is an unfiltered Tile.

In a Web Browser, I can take the same URL and it applies the Filter properly.
URL (copy paste from Power Apps into Browser): https://app.powerbi.com/reportEmbed?reportId=<...>&autoAuth=true&ctid=<...>&pageName=ReportSection2dab4418ac0c00e36368&filterPaneEnabled=false&navContentPaneEnabled=false&$filter=Fact_DemCapAct/DemandID%20eq%20%2733%27
The result is a filtered report.
In PowerApps - I tried hardcoded Filter, removing some report options, replacing SPACE and "'" directly in Power BI, Starting with a new tile from scratch - it all did not fix the issue.

Did anyone experience a similar problem lately and fixed it? Any help or comments are highly appreciated.

Thanks
Sascha
SanderHBI 12 on 30 Mar 2021 at 10:22:43

Like (0)

Report

Re: Powerbi tile filter not working

Thanks. I missed the string part.
Verified answer

v-jefferni on 29 Mar 2021 at 07:49:53

Like (0)

Report
Re: Powerbi tile filter not working

Hi @SanderHBI ,

Please note that:
Filtering feature has the following limitations:
Only one filter can be applied.
Only the eq operator is supported.
Field type must be string.
Filtering is only available on pinned visualization tiles. It's not supported for pinned reports.
You can use computed fields in the Power BI report to convert other value types to string or combines multiple fields into one.

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
SanderHBI 12 on 26 Mar 2021 at 11:20:12

Like (1)

Report

Re: Powerbi tile filter not working

Hi, sorry doesn't work.

It does show the data unfiltered as before but the filter isn't applied.
v-jefferni on 26 Mar 2021 at 01:30:41

Like (0)

Report
Re: Powerbi tile filter not working

Hi @SanderHBI ,

Would you like to pass a parameter to Power Bi tile URL?

If so, please try append below code after:
&$filter=PowerApp_Belichting_Basislijn/BedrijfLocatieId eq '4'

Below is the official doc about above scenario:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-power-bi-tile#pass-a-parameter

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.