Measures Do Not Display when Connected to PowerPivot

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


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


  • Tableau Desktop
  • Microsoft PowerPivot


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?