Initialization of data source failed when exporting cube to Excel

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.