Forum Discussion
subhadip
8 years agoHelper II
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...
v-piga-msft
8 years agoResident Rockstar
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
8 years agoHelper II
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