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
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.