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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
84 | |
79 | |
68 |
User | Count |
---|---|
120 | |
110 | |
94 | |
81 | |
77 |