Forum Discussion

subhadip's avatar
subhadip
Helper II
8 years ago

Query Parameter in Power BI Desktop

How to pass parameter using query string for complicated parameter (string consists of comma , semi colon apostrophe)when deployed pbix file in app.power Site called from external application.

 

Currently for simple parameter it is working.

 

URL?filter=Table/Field eq 'value'

 

but for complicated value (abc  , xyz , p'qr) how do we pass these type of values in query string to filter the data .

 

Please suggest 

Need Help

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi subhadip，

     but for complicated value (abc  , xyz , p'qr) how do we pass these type of values in query string to filter the data .

     

    By my tests, the value only support the comma, the apostrophe is not supported.

     

     

     

    There is no good way to support the apostrophe, I suggest you 'd better don't use the apostrophe in value.

     

    Reference：https://docs.microsoft.com/en-us/power-bi/service-url-filters

     

    Best Regards,

    Cherry

    • subhadip's avatar
      subhadip
      Helper II
      8 years ago

      How do we pass the value in Query string 

      ?filter=Table/ColumnName eq 'abc,xyz,pqr'

       

      comma is not getting recognized in query string . Please suggest the syntax or link which helps