Initialization of data source failed when exporting cube to Excel
Updated On:14-08-2015 02:17
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
Set in control panel the region and language dialog to format English (United States), and hitapply.
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.
Return to the region and language dialog, revert it back to your country setting (in my case Dutch (Belgium)) and click OK.