You cannot create a PivotTable in Excel 2013 when field names in a source range contain similar characters

Symptoms

Consider the following scenario:

• You have two field names in a source range that have similar characters. For example, one field is named "Hello2World," and the other field is named "Hello²World." The "²" character corresponds to the "178" character in ASCII.
• You try to create a PivotTable by selecting the source range in Microsoft Excel 2013.
• You select the Add this data to the Data Model check box in the Create PivotTable dialog box.

In this scenario, you receive the following error message:

We couldn't get data from the Data Model. Here's the error we got: 

The attribute with the name of Hello<sup>2</sup>World already exists in the '**Range**' dimension.

Cause

This issue occurs because the data model cannot differentiate between the similar characters.

Workaround

To work around this issue, change one field name to be distinct from the other.

Status

This is a known issue in Excel 2013.