The Program Wont Start

[LucaBaluc]

I had Power BI 64 with latest version of this program and it works
I need to uninstall Power BI 64 in spite of 32 and the program stopped to work.
The issue was not solved also reinstalling the program in older version or passing from Office 2019 to 365
Luca

[marcosqlbi]

When you say that the program doesn't work you mean that the Analyze in Excel addin doesn't start? Or do you see an error?

[LucaBaluc]

The program try to start but wont
If you execute it manually it does not appear a window message like in a working installation

[marcosqlbi]

Can you check whether you have some message in the Application log of the Event Viewer?
https://learn.microsoft.com/en-us/shows/inside/event-viewer

[LucaBaluc]

These are the errors... Nome registro: Application Origine: Application Error Data: 04/04/2024 08:40:37 ID evento: 1000 Categoria attività:(100) Livello: Errore Parole chiave: Classico Utente: N/D Computer: xxxx Descrizione: Nome dell'applicazione che ha generato l'errore: AnalyzeInExcel.exe, versione: 1.1.0.0, timestamp: 0x904c1dcb Nome del modulo che ha generato l'errore: KERNELBASE.dll, versione: 10.0.17763.475, timestamp: 0x69a188f0 Codice eccezione: 0xe0434352 Offset errore 0x0000000000039129 ID processo che ha generato l'errore: 0x611c Ora di avvio dell'applicazione che ha generato l'errore: 0x01da865b00316fae Percorso dell'applicazione che ha generato l'errore: C:\Program Files (x86)\Sqlbi\Analyze in Excel for Power BI Desktop\AnalyzeInExcel.exe Percorso del modulo che ha generato l'errore: C:\WINDOWS\System32\KERNELBASE.dll ID segnalazione: 9f34095d-18df-4dcb-ac39-dbaa84f02104 Nome completo pacchetto che ha generato l'errore: ID applicazione relativo al pacchetto che ha generato l'errore: XML evento: <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <System> <Provider Name="Application Error" /> <EventID Qualifiers="0">1000</EventID> <Level>2</Level> <Task>100</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2024-04-04T06:40:37.454616800Z" /> <EventRecordID>307109</EventRecordID> <Channel>Application</Channel> <Computer>PC131.zacmi.lan</Computer> <Security /> </System> <EventData> <Data>AnalyzeInExcel.exe</Data> <Data>1.1.0.0</Data> <Data>904c1dcb</Data> <Data>KERNELBASE.dll</Data> <Data>10.0.17763.475</Data> <Data>69a188f0</Data> <Data>e0434352</Data> <Data>0000000000039129</Data> <Data>611c</Data> <Data>01da865b00316fae</Data> <Data>C:\Program Files (x86)\Sqlbi\Analyze in Excel for Power BI Desktop\AnalyzeInExcel.exe</Data> <Data>C:\WINDOWS\System32\KERNELBASE.dll</Data> <Data>9f34095d-18df-4dcb-ac39-dbaa84f02104</Data> <Data> </Data> <Data> </Data> </EventData> </Event> Nome registro: Application Origine: .NET Runtime Data: 04/04/2024 08:40:37 ID evento: 1026 Categoria attività:Nessuna Livello: Errore Parole chiave: Classico Utente: N/D Computer: xxxxx Descrizione: Applicazione: AnalyzeInExcel.exe Versione framework: v4.0.30319 Descrizione: il processo è stato terminato a causa di un'eccezione non gestita. Informazioni sull'eccezione: System.InvalidOperationException in System.Data.OleDb.OleDbServicesWrapper.GetDataSource(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.DataSourceWrapper ByRef) in System.Data.OleDb.OleDbConnectionInternal..ctor(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.OleDbConnection) in System.Data.OleDb.OleDbConnectionFactory.CreateConnection(System.Data.Common.DbConnectionOptions, System.Data.Common.DbConnectionPoolKey, System.Object, System.Data.ProviderBase.DbConnectionPool, System.Data.Common.DbConnection) in System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionPoolGroup, System.Data.Common.DbConnectionOptions) in System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(System.Data.Common.DbConnection, System.Threading.Tasks.TaskCompletionSource`1<System.Data.ProviderBase.DbConnectionInternal>, System.Data.Common.DbConnectionOptions, System.Data.ProviderBase.DbConnectionInternal, System.Data.ProviderBase.DbConnectionInternal ByRef) in System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionFactory, System.Threading.Tasks.TaskCompletionSource`1<System.Data.ProviderBase.DbConnectionInternal>, System.Data.Common.DbConnectionOptions) in System.Data.ProviderBase.DbConnectionInternal.OpenConnection(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionFactory) in System.Data.OleDb.OleDbConnection.Open() in AnalyzeInExcel.ModelHelper.GetModelName(System.String, System.String, AnalyzeInExcel.TelemetryHelper) in AnalyzeInExcel.App.OnStartup(System.Windows.StartupEventArgs) in System.Windows.Application.<.ctor>b__1_0(System.Object) in System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32) in System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate) in System.Windows.Threading.DispatcherOperation.InvokeImpl() in System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) in System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) in System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object) in MS.Internal.CulturePreservingExecutionContext.Run(MS.Internal.CulturePreservingExecutionContext, System.Threading.ContextCallback, System.Object) in System.Windows.Threading.DispatcherOperation.Invoke() in System.Windows.Threading.Dispatcher.ProcessQueue() in System.Windows.Threading.Dispatcher.WndProcHook(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef) in MS.Win32.HwndWrapper.WndProc(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef) in MS.Win32.HwndSubclass.DispatcherCallbackOperation(System.Object) in System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32) in System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate) in System.Windows.Threading.Dispatcher.LegacyInvokeImpl(System.Windows.Threading.DispatcherPriority, System.TimeSpan, System.Delegate, System.Object, Int32) in MS.Win32.HwndSubclass.SubclassWndProc(IntPtr, Int32, IntPtr, IntPtr) in MS.Win32.UnsafeNativeMethods.DispatchMessage(System.Windows.Interop.MSG ByRef) in System.Windows.Threading.Dispatcher.PushFrameImpl(System.Windows.Threading.DispatcherFrame) in System.Windows.Application.RunDispatcher(System.Object) in System.Windows.Application.RunInternal(System.Windows.Window) in AnalyzeInExcel.App.Main() XML evento: <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <System> <Provider Name=".NET Runtime" /> <EventID Qualifiers="0">1026</EventID> <Level>2</Level> <Task>0</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2024-04-04T06:40:37.386787200Z" /> <EventRecordID>307108</EventRecordID> <Channel>Application</Channel> <Computer>xxx</Computer> <Security /> </System> <EventData> <Data>Applicazione: AnalyzeInExcel.exe Versione framework: v4.0.30319 Descrizione: il processo è stato terminato a causa di un'eccezione non gestita. Informazioni sull'eccezione: System.InvalidOperationException in System.Data.OleDb.OleDbServicesWrapper.GetDataSource(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.DataSourceWrapper ByRef) in System.Data.OleDb.OleDbConnectionInternal..ctor(System.Data.OleDb.OleDbConnectionString, System.Data.OleDb.OleDbConnection) in System.Data.OleDb.OleDbConnectionFactory.CreateConnection(System.Data.Common.DbConnectionOptions, System.Data.Common.DbConnectionPoolKey, System.Object, System.Data.ProviderBase.DbConnectionPool, System.Data.Common.DbConnection) in System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionPoolGroup, System.Data.Common.DbConnectionOptions) in System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(System.Data.Common.DbConnection, System.Threading.Tasks.TaskCompletionSource`1&lt;System.Data.ProviderBase.DbConnectionInternal&gt;, System.Data.Common.DbConnectionOptions, System.Data.ProviderBase.DbConnectionInternal, System.Data.ProviderBase.DbConnectionInternal ByRef) in System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionFactory, System.Threading.Tasks.TaskCompletionSource`1&lt;System.Data.ProviderBase.DbConnectionInternal&gt;, System.Data.Common.DbConnectionOptions) in System.Data.ProviderBase.DbConnectionInternal.OpenConnection(System.Data.Common.DbConnection, System.Data.ProviderBase.DbConnectionFactory) in System.Data.OleDb.OleDbConnection.Open() in AnalyzeInExcel.ModelHelper.GetModelName(System.String, System.String, AnalyzeInExcel.TelemetryHelper) in AnalyzeInExcel.App.OnStartup(System.Windows.StartupEventArgs) in System.Windows.Application.&lt;.ctor&gt;b__1_0(System.Object) in System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32) in System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate) in System.Windows.Threading.DispatcherOperation.InvokeImpl() in System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) in System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) in System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object) in MS.Internal.CulturePreservingExecutionContext.Run(MS.Internal.CulturePreservingExecutionContext, System.Threading.ContextCallback, System.Object) in System.Windows.Threading.DispatcherOperation.Invoke() in System.Windows.Threading.Dispatcher.ProcessQueue() in System.Windows.Threading.Dispatcher.WndProcHook(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef) in MS.Win32.HwndWrapper.WndProc(IntPtr, Int32, IntPtr, IntPtr, Boolean ByRef) in MS.Win32.HwndSubclass.DispatcherCallbackOperation(System.Object) in System.Windows.Threading.ExceptionWrapper.InternalRealCall(System.Delegate, System.Object, Int32) in System.Windows.Threading.ExceptionWrapper.TryCatchWhen(System.Object, System.Delegate, System.Object, Int32, System.Delegate) in System.Windows.Threading.Dispatcher.LegacyInvokeImpl(System.Windows.Threading.DispatcherPriority, System.TimeSpan, System.Delegate, System.Object, Int32) in MS.Win32.HwndSubclass.SubclassWndProc(IntPtr, Int32, IntPtr, IntPtr) in MS.Win32.UnsafeNativeMethods.DispatchMessage(System.Windows.Interop.MSG ByRef) in System.Windows.Threading.Dispatcher.PushFrameImpl(System.Windows.Threading.DispatcherFrame) in System.Windows.Application.RunDispatcher(System.Object) in System.Windows.Application.RunInternal(System.Windows.Window) in AnalyzeInExcel.App.Main() </Data> </EventData> </Event> Il giorno gio 4 apr 2024 alle ore 01:17 Marco Russo < ***@***.***> ha scritto:

…

Can you check whether you have some message in the Application log of the Event Viewer? https://learn.microsoft.com/en-us/shows/inside/event-viewer — Reply to this email directly, view it on GitHub <#13 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BHMK6ICT5CA7XWDMNSS2YT3Y3SEYPAVCNFSM6AAAAABFLJFOXSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAMZVG44TINRSHA> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[albertospelta]

It seems to be an issue related to the MSOLAP OLE DB drivers. Could you please verify if they are installed and in which version? You may need to check both the x86 version located in the folder C:\Program Files (x86)\ and the x64 located in the folder C:\Program Files\. To do so, you can refer to this link: https://learn.microsoft.com/en-us/analysis-services/client-libraries?view=asallproducts-allversions#check-installed-versions

[LucaBaluc]

C:\Program Files\Microsoft Analysis Services\AS OLEDB\140 Version 15.1.108.23 same in C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\140 Il giorno gio 4 apr 2024 alle ore 15:44 Alberto Spelta < ***@***.***> ha scritto:

…

It seems to be an issue related to the MSOLAP OLE DB drivers. Could you please verify if they are installed and in which version? You may need to check both the x86 version located in the folder C:\Program Files (x86)\ and the x64 located in the folder C:\Program Files\. To do so, you can refer to this link: https://learn.microsoft.com/en-us/analysis-services/client-libraries?view=asallproducts-allversions#check-installed-versions — Reply to this email directly, view it on GitHub <#13 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BHMK6IE4O2MFKNDIP3CDXZDY3VKNLAVCNFSM6AAAAABFLJFOXSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDAMZXGI3DKOJWGE> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[albertospelta]

I tried to reproduce the issue even by installing the 32-bit version, but I couldn't replicate the error. As a test, if you install PBIDesktop x64 alongside the 32-bit version, does the AnalyzeInExcel tool start working with the 32-bit version?

[LucaBaluc]

Nope (Now it does not work with 32 or 64 bits) Il giorno mar 9 apr 2024 alle ore 15:48 Alberto Spelta < ***@***.***> ha scritto:

…

I tried to reproduce the issue even by installing the 32-bit version, but I couldn't replicate the error. As a test, if you install PBIDesktop x64 alongside the 32-bit version, does the AnalyzeInExcel tool start working with the 32-bit version? — Reply to this email directly, view it on GitHub <#13 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BHMK6IB6WUFR4MFPXS5PSBTY4PWSZAVCNFSM6AAAAABFLJFOXSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDANBVGIZDENJSHA> . You are receiving this because you authored the thread.Message ID: ***@***.***>