locked
Error after loading data RRS feed

  • Question

  • Whenever I try to load data into powerpivot it says it loaded it ok. But when I close the loading wizard it results in an error:

    Unable to load tables into Powerpivot environment

    ============================
    Error Message:
    ============================

    Customized cultures cannot be passed by LCID, only by name.
    ----------------------------
    The type initializer for 'Microsoft.AnalysisServices.Modeler.Controls.TableWidgetColumnFormating' threw an exception.

    ============================
    Call Stack:
    ============================

       at System.Globalization.RegionInfo..ctor(Int32 culture)
       at Microsoft.AnalysisServices.Modeler.Controls.TableWidgetColumnFormating..cctor()
    ----------------------------
       at Microsoft.AnalysisServices.Modeler.Controls.TableWidgetColumnFormating.GetDefaultFormatingOption(BasicDataType type)
       at Microsoft.AnalysisServices.Modeler.Controls.TableWidgetGridControl.ApplyColumnFormat(TableWidgetGridColumn& column)
       at Microsoft.AnalysisServices.Modeler.Controls.TableWidgetGridControl.InitializeGridLayout(Boolean isReset)
       at Microsoft.AnalysisServices.Modeler.Controls.TableWidgetGridControl.SetStorageTable(ITableDataView value, Stream stream)
       at Microsoft.AnalysisServices.Modeler.ClientWindow.Office12Ribbon.Forms.ClientWindow.PopulateTableWidget(String tableId)
       at Microsoft.AnalysisServices.Modeler.ClientWindow.Office12Ribbon.Forms.ClientWindow.sheetsTab_sheetChanged(Object sender, EventArgs e)
       at System.EventHandler.Invoke(Object sender, EventArgs e)
       at Microsoft.AnalysisServices.Modeler.ClientWindow.Office12Ribbon.Controls.SheetTabs.SetSelectedSheetInternal(String key)
       at Microsoft.AnalysisServices.Modeler.ClientWindow.Office12Ribbon.Controls.SheetTabs.PopulateSheetList(String selKey)
       at Microsoft.AnalysisServices.Modeler.ClientWindow.Office12Ribbon.Forms.ClientWindow.RefreshClientWindow(String tableName)

    ============================

    I tried access, Excel and Oracle as datasource. I have the same error in 32bit XP as in 64bit Vista. 

    Does anyone have an idea what I'm doing wrong?


    p.s.
    I installed the shared Office tools.
    • Edited by JoostB1 Thursday, November 19, 2009 2:05 PM ps
    Thursday, November 19, 2009 1:57 PM

Answers

  • This is a known bug in PowerPivot. The problem is that PowerPivot did not support custom locales.
    If you encountered this it means that you have a custom locale installed.
    It doesn't matter what is your current locale.

    We have fixed for this, and it will become available with a next release.
    Tuesday, November 24, 2009 1:12 AM

All replies

  • 1) What is your operating system language and regional settings language?
    2) What is your Excel language?
    2) Until we figure out the real problem, can you try these steps

    a) Open Excel
    b) Click on PowerPivot Tab
    c) Click on Options & Diagnostics
    d) Click on Language tab
    e) Choose the language from the drop down as English United States
    f) Change your regional settings to English United States

    and try the same operation.

    Thanks,
    Deva [MSFT]

    Deva
    Thursday, November 19, 2009 4:19 PM
  • Thanks for your help, my answers
     
    1) Windows 7 Ultimate 64 bit build 7600
    2) Default (English US)
    3) Was dutch, changed that to us english

    no success, I rebooted and still no luck.

    I will change the system locale (also dutch) and try again. This needs an extra reboot.

    ----
    Changing the system locale did not work. 
    Thursday, November 19, 2009 7:55 PM
  • I will reinstall office and Powerpivot.
    ----
    still the same error
    Thursday, November 19, 2009 8:09 PM
  • What is your Excel Language?
    The only thing I would change is your regional settings from Dutch to Englist for testing purpose.

    I don't think you have to re-install here.

    Thanks,
    Deva [MSFT]
    Deva
    Thursday, November 19, 2009 9:25 PM
  • My Excel language is English (U.S.)

    when pressing the 'Preview & Filter'button I get a more detailled error message

    See the end of this message for details on invoking 
    just-in-time (JIT) debugging instead of this dialog box.

    ************** Exception Text **************
    System.TypeInitializationException: The type initializer for 'Microsoft.AnalysisServices.Modeler.Controls.TableWidgetColumnFormating' threw an exception. ---> System.ArgumentException: Customized cultures cannot be passed by LCID, only by name.
       at System.Globalization.RegionInfo..ctor(Int32 culture)
       at Microsoft.AnalysisServices.Modeler.Controls.TableWidgetColumnFormating..cctor()
       --- End of inner exception stack trace ---
       at Microsoft.AnalysisServices.Modeler.Controls.TableWidgetColumnFormating.GetDefaultFormatingOption(BasicDataType type)
       at Microsoft.AnalysisServices.Modeler.Controls.TableWidgetGridControl.ApplyColumnFormat(TableWidgetGridColumn& column)
       at Microsoft.AnalysisServices.Modeler.Controls.TableWidgetGridControl.InitializeGridLayout(Boolean isReset)
       at Microsoft.AnalysisServices.Modeler.Controls.TableWidgetGridControl.SetStorageTable(ITableDataView value, Stream stream)
       at Microsoft.AnalysisServices.Modeler.DataImportWizard.PreviewPage.SetTableWidgetPanelData()
       at Microsoft.AnalysisServices.Modeler.DataImportWizard.TableSelectionPageObject.ShowPreview(Object sender, EventArgs e)
       at Microsoft.AnalysisServices.Modeler.DataImportWizard.ProgressControl.timerTaskComplete_Tick(Object sender, EventArgs e)
       at System.Windows.Forms.Timer.OnTick(EventArgs e)
       at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)
       at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


    ************** Loaded Assemblies **************
    mscorlib
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
        CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Office.Runtime.v10.0
        Assembly Version: 10.0.0.0
        Win32 Version: 10.0.20825.1
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Runtime.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Runtime.v10.0.dll
    ----------------------------------------
    System
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
    ----------------------------------------
    System.Core
        Assembly Version: 3.5.0.0
        Win32 Version: 3.5.30729.4926 built by: NetFXw7
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
    ----------------------------------------
    System.AddIn
        Assembly Version: 3.5.0.0
        Win32 Version: 3.5.30729.4926 built by: NetFXw7
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.AddIn/3.5.0.0__b77a5c561934e089/System.AddIn.dll
    ----------------------------------------
    System.Configuration
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
    ----------------------------------------
    System.Xml
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
    ----------------------------------------
    System.Security
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Security/2.0.0.0__b03f5f7f11d50a3a/System.Security.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0
        Assembly Version: 10.0.0.0
        Win32 Version: 10.0.20825.1
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0
        Assembly Version: 10.0.0.0
        Win32 Version: 10.0.20825.1
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0.dll
    ----------------------------------------
    System.Deployment
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Deployment/2.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0
        Assembly Version: 10.0.0.0
        Win32 Version: 10.0.20825.1
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0
        Assembly Version: 9.0.0.0
        Win32 Version: 9.0.30729.4130
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0.dll
    ----------------------------------------
    System.Windows.Forms
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
    ----------------------------------------
    System.Drawing
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
    ----------------------------------------
    System.Xml.Linq
        Assembly Version: 3.5.0.0
        Win32 Version: 3.5.30729.4926 built by: NetFXw7
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml.Linq/3.5.0.0__b77a5c561934e089/System.Xml.Linq.dll
    ----------------------------------------
    System.AddIn.Contract
        Assembly Version: 2.0.0.0
        Win32 Version: 3.5.30729.4926 built by: NetFXw7
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.AddIn.Contract/2.0.0.0__b03f5f7f11d50a3a/System.AddIn.Contract.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Office.Contract.v9.0
        Assembly Version: 9.0.0.0
        Win32 Version: 9.0.30729.4130
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Contract.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Contract.v9.0.dll
    ----------------------------------------
    Microsoft.Office.Tools.v9.0
        Assembly Version: 9.0.0.0
        Win32 Version: 9.0.30729.4130
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.Office.Tools.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.v9.0.dll
    ----------------------------------------
    Microsoft.AnalysisServices.Modeler.FieldList
        Assembly Version: 10.0.0.0
        Win32 Version: 10.50.1352.12 ((KJ_PreRelease).091030-1757 )
        CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/10/Microsoft.AnalysisServices.Modeler.FieldList.DLL
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Office.Excel.AddInAdapter.v9.0
        Assembly Version: 9.0.0.0
        Win32 Version: 9.0.30729.4130
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Excel.AddInAdapter.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Excel.AddInAdapter.v9.0.dll
    ----------------------------------------
    Microsoft.Office.Tools.Common.v9.0
        Assembly Version: 9.0.0.0
        Win32 Version: 9.0.30729.4130
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.Office.Tools.Common.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Common.v9.0.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Office.AddInAdapter.v9.0
        Assembly Version: 9.0.0.0
        Win32 Version: 9.0.30729.4130
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.AddInAdapter.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.AddInAdapter.v9.0.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Applications.AddInAdapter.v9.0
        Assembly Version: 9.0.0.0
        Win32 Version: 9.0.30729.4130
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.AddInAdapter.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.AddInAdapter.v9.0.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Applications.Contract.v9.0
        Assembly Version: 9.0.0.0
        Win32 Version: 9.0.30729.4130
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Contract.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Contract.v9.0.dll
    ----------------------------------------
    Anonymously Hosted DynamicMethods Assembly
        Assembly Version: 0.0.0.0
        Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
        CodeBase: file:///C:/Windows/assembly/GAC_64/mscorlib/2.0.0.0__b77a5c561934e089/mscorlib.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Applications.Adapter.v9.0
        Assembly Version: 9.0.0.0
        Win32 Version: 9.0.30729.4130
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Adapter.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Adapter.v9.0.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Office.Excel.HostAdapter.v10.0
        Assembly Version: 10.0.0.0
        Win32 Version: 10.0.20825.1
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Excel.HostAdapter.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Excel.HostAdapter.v10.0.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Office.HostAdapter.v10.0
        Assembly Version: 10.0.0.0
        Win32 Version: 10.0.20825.1
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.HostAdapter.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.HostAdapter.v10.0.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Applications.ServerDocument.v9.0
        Assembly Version: 9.0.0.0
        Win32 Version: 9.0.30729.4130
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v9.0.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Office.Excel.AddInProxy.v9.0
        Assembly Version: 9.0.0.0
        Win32 Version: 9.0.30729.4130
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Excel.AddInProxy.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Excel.AddInProxy.v9.0.dll
    ----------------------------------------
    Microsoft.VisualStudio.Tools.Office.Contract.v10.0
        Assembly Version: 10.0.0.0
        Win32 Version: 10.0.20825.1
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Contract.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Contract.v10.0.dll
    ----------------------------------------
    Microsoft.Office.Interop.Excel
        Assembly Version: 14.0.0.0
        Win32 Version: 14.0.4514.1004
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.Office.Interop.Excel/14.0.0.0__71e9bce111e9429c/Microsoft.Office.Interop.Excel.dll
    ----------------------------------------
    office
        Assembly Version: 14.0.0.0
        Win32 Version: 14.0.4536.1000
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/office/14.0.0.0__71e9bce111e9429c/office.dll
    ----------------------------------------
    WindowsBase
        Assembly Version: 3.0.0.0
        Win32 Version: 3.0.6920.4902 built by: NetFXw7
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/WindowsBase/3.0.0.0__31bf3856ad364e35/WindowsBase.dll
    ----------------------------------------
    System.Data
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
        CodeBase: file:///C:/Windows/assembly/GAC_64/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
    ----------------------------------------
    Accessibility
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
    ----------------------------------------
    Microsoft.AnalysisServices.Common
        Assembly Version: 10.0.0.0
        Win32 Version: 10.50.1352.12 ((KJ_PreRelease).091030-1757 )
        CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/10/Microsoft.AnalysisServices.Common.DLL
    ----------------------------------------
    Microsoft.AnalysisServices.Modeler.Storage
        Assembly Version: 10.0.0.0
        Win32 Version: 10.50.1352.12 ((KJ_PreRelease).091030-1757 )
        CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/10/Microsoft.AnalysisServices.Modeler.Storage.DLL
    ----------------------------------------
    Microsoft.AnalysisServices.Modeler
        Assembly Version: 10.0.0.0
        Win32 Version: 10.50.1352.12 ((KJ_PreRelease).091030-1757 )
        CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/10/Microsoft.AnalysisServices.Modeler.DLL
    ----------------------------------------
    Microsoft.DataWarehouse
        Assembly Version: 10.0.0.0
        Win32 Version: 10.50.1352.12 ((KJ_PreRelease).091030-1758 )
        CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/10/Microsoft.DataWarehouse.DLL
    ----------------------------------------
    CustomMarshalers
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
        CodeBase: file:///C:/Windows/assembly/GAC_64/CustomMarshalers/2.0.0.0__b03f5f7f11d50a3a/CustomMarshalers.dll
    ----------------------------------------
    msmgdsrv
        Assembly Version: 9.0.0.0
        Win32 Version: 2009.0100.1352.012
        CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20OLEDB/10/msmgdsrv.dll
    ----------------------------------------
    Microsoft.AnalysisServices.AdomdClient
        Assembly Version: 10.0.0.0
        Win32 Version: 10.50.1352.12 ((KJ_PreRelease).091030-1757 )
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.AnalysisServices.AdomdClient/10.0.0.0__89845dcd8080cc91/Microsoft.AnalysisServices.AdomdClient.dll
    ----------------------------------------
    Microsoft.AnalysisServices
        Assembly Version: 10.0.0.0
        Win32 Version: 10.50.1352.12 ((KJ_PreRelease).091030-1757 )
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.AnalysisServices/10.0.0.0__89845dcd8080cc91/Microsoft.AnalysisServices.dll
    ----------------------------------------
    Microsoft.AnalysisServices.Wizard.v1
        Assembly Version: 10.0.0.0
        Win32 Version: 10.50.1352.12 ((KJ_PreRelease).091030-1758 )
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.AnalysisServices.Wizard.v1/10.0.0.0__89845dcd8080cc91/Microsoft.AnalysisServices.Wizard.v1.dll
    ----------------------------------------
    Microsoft.SqlServer.Configuration.SString
        Assembly Version: 10.0.0.0
        Win32 Version: 10.50.1352.12 ((KJ_PreRelease).091030-1757 )
        CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/10/Microsoft.SqlServer.Configuration.SString.DLL
    ----------------------------------------
    Microsoft.Data.DataFeedClient
        Assembly Version: 10.0.0.0
        Win32 Version: 10.50.1352.12 ((KJ_PreRelease).091030-1757 )
        CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/10/Microsoft.Data.DataFeedClient.DLL
    ----------------------------------------
    Microsoft.Data.ConnectionUI.Dialog
        Assembly Version: 8.0.0.0
        Win32 Version: 8.0.50727.762 (SP.050727-7600)
        CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/10/Microsoft.Data.ConnectionUI.Dialog.DLL
    ----------------------------------------
    Microsoft.Data.ConnectionUI
        Assembly Version: 8.0.0.0
        Win32 Version: 8.0.50727.762 (SP.050727-7600)
        CodeBase: file:///C:/Program%20Files/Microsoft%20Analysis%20Services/AS%20Excel%20Client/10/Microsoft.Data.ConnectionUI.DLL
    ----------------------------------------
    System.Data.OracleClient
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
        CodeBase: file:///C:/Windows/assembly/GAC_64/System.Data.OracleClient/2.0.0.0__b77a5c561934e089/System.Data.OracleClient.dll
    ----------------------------------------
    System.Transactions
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
        CodeBase: file:///C:/Windows/assembly/GAC_64/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
    ----------------------------------------
    System.EnterpriseServices
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
        CodeBase: file:///C:/Windows/assembly/GAC_64/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
    ----------------------------------------
    System.Data.SqlXml
        Assembly Version: 2.0.0.0
        Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
        CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Data.SqlXml/2.0.0.0__b77a5c561934e089/System.Data.SqlXml.dll
    ----------------------------------------

    ************** JIT Debugging **************
    To enable just-in-time (JIT) debugging, the .config file for this
    application or computer (machine.config) must have the
    jitDebugging value set in the system.windows.forms section.
    The application must also be compiled with debugging
    enabled.

    For example:

    <configuration>
        <system.windows.forms jitDebugging="true" />
    </configuration>

    When JIT debugging is enabled, any unhandled exception
    will be sent to the JIT debugger registered on the computer
    rather than be handled by this dialog box.


    • Edited by JoostB1 Friday, November 20, 2009 7:42 AM added error message
    Friday, November 20, 2009 7:37 AM
  • Thanks for the info.
    Have you tried to switch the regional settings locale to English US and try it.
    We have identified the issues and fixed but it will be available only in RTM.
    For now the workaround is to make sure your regional settings locale is english US.
    Sorry for the incovenience.

    Thanks,
    Deva [MSFT]


    Deva
    Friday, November 20, 2009 2:00 PM
  • I've done that. But I still have the error. 
    I set my language in the following ways
    - Windows settings -> Region and Language -> Format -> english US 
    - Windows settings -> Region and Language -> Location-> US 
    - Windows settings -> Region and Language -> display languages-> english (uninstalled dutch)
    - Windows settings -> Region and Language -> keyboard settings-> englisch us
    - Windows settings -> Region and Language -> administrative -> system locale -> english us
    - Excel settings -> options -> language -> Everything english us

    anything I overlooked?
    Saturday, November 21, 2009 12:09 PM
  • This is a known bug in PowerPivot. The problem is that PowerPivot did not support custom locales.
    If you encountered this it means that you have a custom locale installed.
    It doesn't matter what is your current locale.

    We have fixed for this, and it will become available with a next release.
    Tuesday, November 24, 2009 1:12 AM