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: