Powerbi tile filter not working

(0) Share

Report

Posted on 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?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

v-jefferni on at

Like (0)

Report
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.

Was this reply helpful? Yes No
SanderHBI 12 on at

Like (1)

Report

Hi, sorry doesn't work.

It does show the data unfiltered as before but the filter isn't applied.

Was this reply helpful? Yes No
Verified answer

v-jefferni on at

Like (0)

Report
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.

Was this reply helpful? Yes No
SanderHBI 12 on at

Like (0)

Report

Thanks. I missed the string part.

Was this reply helpful? Yes No
Sascha1979 4 on at

Like (0)

Report

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

Was this reply helpful? Yes No
AlanChai 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Sascha1979 4 on at

Like (0)

Report

Thanks, this worked. Solution accepted.

Was this reply helpful? Yes No
TJacobson 2 on at

Like (0)

Report

Just FYI that setting Allow New Api to "True" for me also worked. I believe that this is contrary to Microsoft's documentation!

Was this reply helpful? Yes No