Forum Discussion

mkavcic's avatar
mkavcic
Frequent Visitor
4 years ago

Field parameters and URL filters

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!

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      mkavcic
      Frequent Visitor

      Hi,

      I am not using any space in table name.

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

       

      So no empty spaces.

      • mkavcic's avatar
        mkavcic
        Frequent Visitor

        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.

         

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

     

    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's avatar
    mkavcic
    Frequent Visitor

    No working solution found.

    I will be reporting an issue/bug.

  • mkavcic's avatar
    mkavcic
    Frequent Visitor

    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.