Measures Do Not Display when Connected to PowerPivot

Published: 11 Apr 2014
Last Modified Date: 22 Jan 2019


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.
  • If the measures used are calculations that rely on other fields, these other fields must also be set to decimal or number, even if they are hidden and do not themselves display in Tableau Desktop.  

Discuss this article... Feedback Forum
Did this article resolve the issue?