Importing data from SSAS into PowerPivot when you have different regional settings
Ok this one is for all of you who like me have to live and work with different regional settings than English US. This makes sure a lot of software behaves not as expected, PowerPivot also has strange behavoir.
When you import data from SSAS into PowerPivot all column are treated as text. This is a by design feature of PowerPivot: