PowerBI tile in PowerApps -column names with spaces not filtering

(0) Share

Report

Posted on by Bubbler

Hi all

After read all the post about this subject, still have a problem to filter PowerBI tile

In tile properties, the url was modified to support spaces:

TileUrl: "https://app.powerbi.com/embed?dashboardId=d7301.... ...fQ%3d%3d&$filter=Volumen_x0020_Historico/Marca eq 'MIRASOL'"

Table Name: [Volumen Historico]
Column Name: [Marca]
Type: String

The resulting tile was not affected by the filter.

After a bunch of tests, I've realized that if I use a table name and a column name without spaces, the filtering occurs as expected.

So,

What should I change in this expression:

&$filter=Volumen_x0020_Historico/Marca eq 'MIRASOL'

Is there any way to debug/understand the error associated with this issue?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-yutliu-msft Microsoft Employee on at

Like (0)

Report

Copy link

Link copied!

Hi @Bubbler ,

That's a little strange...

Your formula seems to be correct.

Please make sure that you have represented every spaces by using "_x0020_".

What's more, Table and Field names are case-sensitive, value isn't.

Please check your formula about case-sensitive.

Here are some common special characters in URL filters:

Identifier	Unicode	Coding for Power BI
Table Name	Space is 0x20	Table_x0020_Name
Column@Number	@ is 0x40	Column_x0040_Number
[Column]	[ is 0x0058 ] is 0x0050	x0058_Column_x0050
Column+Plus	+ is 0x2B	Column_x002B_Plus

Please modify your formula based on this.

Here's a doc about this in details for your reference:

https://docs.microsoft.com/en-us/power-bi/service-url-filters#special-characters-in-url-filters

What's more, you could change other browsers to test it. I found that someone met this problem because of browser's cache.So you could try to clean your browser's cache to solve this.

Here's the issue:

https://community.powerbi.com/t5/Report-Server/Filter-report-with-URL-query-paramaters/td-p/296918

Best regards,

Was this reply helpful? Yes No

Bubbler 36 on at

Like (0)

Report
Copy link

Link copied!

Strange things, yes
I've cleaned cache, close and reopen, change browser... same issue. Even at the phone using the powerapps app
Attached you will find PowerBI model definition and values.

Any other clues? Region or language reported issues?

Was this reply helpful? Yes No