KNOWLEDGE BASE

Measures Do Not Display when Connected to PowerPivot


Published: 11 Apr 2014
Last Modified Date: 08 Apr 2015

Issue

When you connect to Microsoft PowerPivot, Tableau Desktop might not recognize some measures as dimensions, and might not import some measures.

Environment

  • Tableau Desktop
  • Microsoft PowerPivot

Cause

Tableau does not detect measure formatting from Microsoft PowerPivot unless the data is formatted as decimal or whole numbers.

Additional Information

You must apply decimal number or whole number formatting to every measure in the PowerPivot file that is formatted as a number in order to import the field into Tableau Desktop correctly.
Did this article resolve the issue?