Query Parameter in Power BI Desktop

[subhadip]

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 

[v-piga-msft]

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]

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