Forum Discussion

subhadip's avatar
subhadip
Icon for Helper II rankHelper 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.   Cu...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident 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
    Icon for Helper II rankHelper 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