| Importing data from SSAS into PowerPivot when you have different regional settings |
| Written by Kasper de Jonge |
| Thursday, 12 August 2010 02:08 |
|
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:
|
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
