PowerPivot does not honour the regional settings of the computer it is running. Hence, the decimal symbol causes PowerPivot calculation to break. - by Sedat Yogurtcuoglu - MSFT

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 611836 Comments
Status Closed Workarounds
Type Bug Repros 5
Opened 10/8/2010 11:38:14 AM
Access Restriction Public
Primary Feedback Item 538102


PowerPivot does not honour the regional settings of the computer it is running. It uses the English digit grouping and decimal symbol characters, regardless what the regional setting is. The languages that have comma as a decimal symbol i.e. Turkish, German, French etc., causes the powerpivot to break.
When I import data into PowerPivot from SSAS DB that contains currency data type measures. The decimal symbol is a DOT whereas it has to be comma (because of the regional settings)
When I create a Pivot table that sums the Measure, I get error indicating incompatible data type, because it treats the measure as text (because of the digit grouping and decimal symbols)
 If I try to format the PowerPivot column Text to Decimal, I get completely wrong data(because the decimal symbol means something else!)
Sign in to post a comment.
Posted by Microsoft on 2/20/2012 at 1:52 PM
Hello Sedat,

We have been able to fix this bug in SQL Server 2012 RTM. Importing measures from AS multidimenstional wil keep the data type. That will make sure this scenario will not happen any more in most cases.

Posted by Microsoft on 3/22/2011 at 3:49 PM
Hello Sedat,

Thank you for your submission. We are aware of this problem and are investigating this issue.

Kasper de Jonge