0 Reports
When using 'Edit Connection' on an OData data source with a filter on Tableau Server, special characters in the filter are replaced by '
Created
Found in Release
2023.3.9
Last Updated
Reference ID
W-17776013
Summary
When using 'Edit Connection' on an OData data source with a filter on Tableau Server, special characters in the filter are replaced by '
Steps to Reproduce
- Create a connection to an OData data source with a filter involving special characters in Tableau Desktop.
- Example: https://sample.odata.org/V4/sampleDatabase/Customers?$filter=startswith(Name,'Alex')
- Alternatively, upgrade any Tableau Sever with similar OData connections to 2023.3.9 or higher.
- Publish the workbook or data source to Tableau Server.
- Browse to the published workbook/data source, switch to the data sources/connections tab, click on the three-dot 'Actions' menu, and select 'Edit Connection'. Change the filter value and save.
- Example: change the connection filter to ?$filter=startswith(Name,'Al')
- Observe the connection information has also changed any special characters in the string.
- Example: https://sample.odata.org/V4/sampleDatabase/Customers?$filter=startswith(Name,'Al')
Workaround
Option 1
Use Webedit to make the modification by selecting either 'Edit Workbook' or 'Edit Data Source' from the actions menu. Republish the changed workbook/data source.
Option 2
Look-up the URL encoding for any special characters and replace them with these values. This will allow the 'Edit Connection' dialog to retain the values.
Example:
Single quote character encodes to %27 so the example URL becomes https://sample.odata.org/V4/sampleDatabase/Customers?$filter=startswith(Name,%27Alex%27)
Reference IDW-17776013
0 Reports