Unable to Change Data Type When Connecting to Published Data Sources

問題

When connecting Tableau Desktop to a data sources on Tableau Server, the user will not be able to change the data type in the data pane or in the data source page. “Geographic role" is the only option available when clicking the data type icon.

User-added image

環境

Tableau Desktop
Tableau Server

解決方法

Option 1

Make a copy of the field in the workbook and change the data type.

Right-click the field which needs to be changed and select Duplicate to make a copy of the field.
Change the data type of the copied field.

Option 2

Create a local copy of the published data source and make the desired changes to the local copy of the data source.

Create a local copy of the published data source by selecting Data > data source > Create Local Copy, and click Save.
Replace the published data source with the new local data source by selecting Data > Replace data source.
Replace Data Source can only occur in the worksheet view and the desired data source must be in use.
Right-click the published data source and then select Close to close the published data source.
Make the desired changes to the local copy of the data source.

原因

This is an expected behavior. The users who are connecting to the published data sources should not be able to change the type of the data, unless the changes have been made by the owners of the published data source on Tableau Server.