New Database Fields Added To Existing Connection Without Friendly Name

問題

When adding new field to a database and refreshing an existing connection in Tableau Desktop to that database, then the new field is imported with the remote database name rather than the cleaned-up friendly name that automatically removes some special characters. For example, column_one instead of Column One.

環境

Tableau Desktop

解決方法

Rename the new fields in Tableau Desktop to the desired friendly name.

原因

By design, fields are given friendly names only at the time the connection to the data source is first made. Tableau Desktop does not know which fields have been previously used, therefore renaming fields with friendly names in an existing connection could break calculated fields, parameters, joins, and blends that rely on those field names.