ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Initialization of data source failed when exporting cube to Excel

book

Article ID: 162226

calendar_today

Updated On:

Products

IT Analytics

Issue/Introduction

When cube is exported to excel, error message popped up.
  XML for Analysis parser: The LocaleIdentifier property is not overwritable and cannot be assigned a new value.

Cause

Issue with Microsoft Analysis Service

Resolution

  1. Set in control panel the region and language dialog to format English (United States), and hitapply.
  2. Start BIDS, Excel or whatever app which is causing problems (I experienced the problem as well with the Tabular models in SSAS 2012, where unfortunately we don't have a language dropbox...) and verify it is now working well, even with default as a language.
  3. Return to the region and language dialog, revert it back to your country setting (in my case Dutch (Belgium)) and click OK.