Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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
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
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |