search cancel

Initialization of data source failed when exporting cube to Excel


Article ID: 162226


Updated On:


IT Analytics


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.


Issue with Microsoft Analysis Service


  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.