Field parameters and URL filters

[mkavcic]

Hi,

I have published a report with field parameter on my dashboard.

I have been trying to reference a field parameter in URL with no success.

How could I use the &filter=Table/Fieldname eq 'Tablename'[Fieldname]   ?

Thank you!

[mkavcic]

Accessing report with URL when using field parameters does not work.

I tried with URL of the report, that I copied from published report and added

&filter=Table/Fieldname eq 'Tablename'[Fieldname]

and it does not work.

It does work without field parameters.

Field parameters have composite key.

I have tried addressing each one of them but it does not work.

DAX studio works when filtering with field parameters, so I used the same logic in URL, but it does not work. 

[mkavcic]

No working solution found.

I will be reporting an issue/bug.

[Anonymous]

Hi @mkavcic ,

I have found a similar post, please refer to it to see if it helps you.

Solved: Power BI ignoring passed parameters in URL - Microsoft Power BI Community

•  pass the filter parameter via $filter=Table/Field eq 'value
• pass the filter parameter by modifying URL like below: 
• https://app.powerbi.com/reportEmbed?reportId=7860e7e8-4acf-4e94-a860-1af6d633ad57&autoAuth=true&ctid...&$filter=DimSalesTerritory/Group eq 'Asia'
• Embed a report in a secure portal or website - Power BI | Microsoft Docs

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @mkavcic ,

Just use "_x0020_" instead of space in the table name, like this:

&filter=Table _x0020_ name.

Special characters in table and column names

Special characters and spaces in table and column names require more formatting. When your query contains spaces, dashes, or other non-ASCII characters, prefix those special characters with an escape code starting with an underscore and an X (_x), then the four-digit Unicode, then another underscore. If the Unicode is fewer than four characters, you need to pad it with zeroes. Here are some examples.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mkavcic]

Hi,

I am not using any space in table name.

My example was  &filter=Table/Fieldname eq 'Tablename'[Fieldname] 

So no empty spaces.

[mkavcic]

Is there anybody that uses URL filtering with FIELD PARAMETERS?

I have searched everywhere and found no working solution.

I have tried all the custom formatting options and URL filtering does not work.
As far as I know, this is a bug.