When using 'Edit Connection' on an OData data source with a filter on Tableau Server, special characters in the filter are replaced by '

Tableau / Tableau Server
In Review

Created

Feb 12, 2025

Found in Release

2023.3.9

Last Updated

Feb 18, 2025

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.
  • 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.



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
In Review

0 Reports

0 Reports