KNOWLEDGE BASE

Unable to Change Data Type When Connecting to Published Data Sources


Published: 21 Mar 2022
Last Modified Date: 25 Mar 2022

Issue

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
User-added image

Environment

  • Tableau Desktop
  • Tableau Server

Resolution

Option 1

Make a copy of the field in the workbook and change the data type.
  1. Right-click the field which needs to be changed and select Duplicate to make a copy of the field.
  2. 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.
  1. Create a local copy of the published data source by selecting Data > data sourceCreate Local Copy, and click Save.
  2. Replace the published data source with the new local data source by selecting Data > Replace data source.
  3. Replace Data Source can only occur in the worksheet view and the desired data source must be in use.
  4. Right-click the published data source and then select Close to close the published data source.
  5. Make the desired changes to the local copy of the data source.

Cause

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.
Did this article resolve the issue?