Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filtering a report using query string parameters for special characters in the URL

Hi everyone,

 

I have been trying to generate a URL to filter a report I use by a specific project, with no luck. Hoping someone can help.


The table and field I want to reference is _test_table/project

I'm using the unicode character 005F, preceded by _x  and followed by _ to account for the underscore before and after "test." 

 

So at the end of the report URL I type ?filter=_x005F_test_x005F_table/project eq 'P-1234'

I've also tried ?filter=_x005F__test_x005F__table/project eq 'P-1234' to include the underscore along with the unicode character for it.

Neither options work. Kudos to anyone who can figure this one out!

 

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Based on my test, you could use underscore directly instead of converting in URL:

     

    ?filter=_test_table/project eq 'P-1234'
     
    Please notice the end of the URL is ReportSection(Sometimes there will be a suffix of a page code)
     
    Best Regards,
    Eyelyn Qin
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you. I appreciate your help here but it's not working for me for some reason. I've tried with a report and an App and receive the below message.

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    According to the error message, it seems that you have trouble logging in Power BI not the URL Filter.

    Please close all brower windows and have a try again.

     

    If it does not make sense , please use another browse or clear cookies & cache.

     

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

     

    Hope to hear from you. Thanks in advanced.😀

     

    Best Regards,
    Eyelyn Qin

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Anonymous . Unfortunately not. The only solution I have found is if I rename my table from _project_table to projecttable without the underscores. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Anonymous ,

         

        Please upgrade your Power BI Desktop to the latest version and have a try again.

         

        The suffix of-->  ?filter=_test_table/project eq 'P-1234' works fine on my side.

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