tabulartools/pbi-explorer

Error when opening a second file to Compare

Opened this issue · 1 comments

Describe the problem

Using the Compare files feature, I attempt to open the 2nd file and get an 'unhandled exception' error message

The 2 files are edited via PBI Desktop and both ~ 225Mb (Import models)

The text from the error details follows:

************** Exception Text **************
System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values. (Parameter 'scalarType')
at PbiExplorer.Shared.Comparers.Helpers.TypeExtensions.GetScalarTypeAndValue(Type scalarType, Object scalarValue)
at PbiExplorer.Shared.Comparers.Generic.GenericObjectComparer.CompareScalarProperty(ReportCompareObject rootNode, String path, Type leftPropertyType, Type rightPropertyType, Object leftObject, Object rightObject, String propertyName, ILogger logger)
at PbiExplorer.Shared.Comparers.Generic.GenericObjectComparer.Compare(ReportCompareObject rootNode, String path, Type leftType, Type rightType, Object leftObject, Object rightObject, String propertyName, ILogger logger)
at PbiExplorer.Shared.Comparers.Generic.GenericObjectComparer.<>c__DisplayClass16_0.b__2(String prop)
at System.Collections.Generic.List1.ForEach(Action1 action)
at PbiExplorer.Shared.Comparers.Generic.GenericObjectComparer.Compare(ReportCompareObject rootNode, String path, Type leftType, Type rightType, Object leftObject, Object rightObject, String propertyName, ILogger logger)
at PbiExplorer.Shared.Comparers.Generic.GenericObjectComparer.CompareReportObjectProperty(ReportCompareObject rootNode, String path, Type leftPropertyType, Type rightPropertyType, Object leftObject, Object rightObject, String propertyName, ILogger logger)
at PbiExplorer.Shared.Comparers.Generic.GenericObjectComparer.Compare(ReportCompareObject rootNode, String path, Type leftType, Type rightType, Object leftObject, Object rightObject, String propertyName, ILogger logger)
at PbiExplorer.Shared.Comparers.Generic.GenericObjectComparer.<>c__DisplayClass16_0.b__2(String prop)
at System.Collections.Generic.List1.ForEach(Action1 action)
at PbiExplorer.Shared.Comparers.Generic.GenericObjectComparer.Compare(ReportCompareObject rootNode, String path, Type leftType, Type rightType, Object leftObject, Object rightObject, String propertyName, ILogger logger)
at PbiExplorer.Shared.Comparers.Generic.GenericObjectComparer.<>c__DisplayClass16_0.b__2(String prop)
at System.Collections.Generic.List1.ForEach(Action1 action)
at PbiExplorer.Shared.Comparers.Generic.GenericObjectComparer.Compare(ReportCompareObject rootNode, String path, Type leftType, Type rightType, Object leftObject, Object rightObject, String propertyName, ILogger logger)
at PbiExplorer.Shared.Comparers.Generic.GenericObjectComparer.CompareListProperty(ReportCompareObject rootNode, String path, Type leftPropertyType, Type rightPropertyType, Object leftObject, Object rightObject, String propertyName, ILogger logger)
at PbiExplorer.Shared.Comparers.Generic.GenericObjectComparer.Compare(ReportCompareObject rootNode, String path, Type leftType, Type rightType, Object leftObject, Object rightObject, String propertyName, ILogger logger)
at PbiExplorer.Shared.Comparers.Generic.GenericObjectComparer.<>c__DisplayClass16_0.b__2(String prop)
at System.Collections.Generic.List1.ForEach(Action1 action)
at PbiExplorer.Shared.Comparers.Generic.GenericObjectComparer.Compare(ReportCompareObject rootNode, String path, Type leftType, Type rightType, Object leftObject, Object rightObject, String propertyName, ILogger logger)
at PbiExplorer.Shared.Comparers.Generic.GenericObjectComparer.CompareListProperty(ReportCompareObject rootNode, String path, Type leftPropertyType, Type rightPropertyType, Object leftObject, Object rightObject, String propertyName, ILogger logger)
at PbiExplorer.Shared.Comparers.Generic.GenericObjectComparer.Compare(ReportCompareObject rootNode, String path, Type leftType, Type rightType, Object leftObject, Object rightObject, String propertyName, ILogger logger)
at PbiExplorer.Shared.Comparers.Generic.GenericObjectComparer.<>c__DisplayClass16_0.b__2(String prop)
at System.Collections.Generic.List1.ForEach(Action1 action)
at PbiExplorer.Shared.Comparers.Generic.GenericObjectComparer.Compare(ReportCompareObject rootNode, String path, Type leftType, Type rightType, Object leftObject, Object rightObject, String propertyName, ILogger logger)
at PbiExplorer.Shared.Comparers.Generic.GenericObjectComparer.CompareReports(Report leftReport, Report rightReport, ILogger logger)
at PbiExplorer.Shared.ReportService.CompareReports(Report leftReport, Report rightReport)
at PbiExplorer.UI.Controllers.ReportComparerController.PerformComparison()
at PbiExplorer.UI.Controllers.ReportComparerController.OpenFileRight(String fileName)
at PbiExplorer.UI.Views.ReportComparerView.OpenFileRight(String fileName)
at PbiExplorer.UI.Main.btnOpenComparisonRight_Click(Object sender, EventArgs e)
at DevExpress.XtraBars.Navigation.AccordionControlElement.RaiseElementClick(MouseButtons mouseButton)
at DevExpress.XtraBars.Navigation.AccordionElementBaseViewInfo.ProcessMouseClick(Boolean shouldSelectElement, MouseButtons mouseButton)
at DevExpress.XtraBars.Navigation.AccordionControlHandler.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at DevExpress.XtraEditors.XtraControl.WndProc(Message& m)
at DevExpress.Utils.Controls.ControlBase.BaseWndProc(Message& m)
at DevExpress.XtraEditors.BaseControl.WndProc(Message& msg)
at DevExpress.XtraBars.Navigation.AccordionControl.WndProc(Message& msg)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, WM msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
System.Private.CoreLib
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

PbiExplorer
Assembly Version: 0.7.2.0
Win32 Version: n/a
CodeBase:

System.Runtime
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.DependencyInjection.Abstractions
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

DevExpress.Utils.v23.1
Assembly Version: 23.1.6.0
Win32 Version: n/a
CodeBase:

System.Windows.Forms
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.ComponentModel.Primitives
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Windows.Forms.Primitives
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Runtime.InteropServices
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Drawing.Primitives
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Collections.Specialized
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Drawing.Common
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

DevExpress.Data.v23.1
Assembly Version: 23.1.6.0
Win32 Version: n/a
CodeBase:

netstandard
Assembly Version: 2.1.0.0
Win32 Version: n/a
CodeBase:

System.Threading
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Diagnostics.TraceSource
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.ApplicationInsights
Assembly Version: 2.21.0.429
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.Hosting
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.Hosting.Abstractions
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.Configuration.Abstractions
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.ComponentModel
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Serilog
Assembly Version: 2.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.DependencyInjection
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Serilog.Extensions.Hosting
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Diagnostics.DiagnosticSource
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Diagnostics.Tracing
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.IO.MemoryMappedFiles
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Private.Uri
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Collections.Concurrent
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.FileProviders.Abstractions
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.FileProviders.Physical
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.Primitives
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.Configuration
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.Configuration.EnvironmentVariables
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.Configuration.FileExtensions
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.Configuration.Binder
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.Configuration.Json
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Linq
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Collections
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.IO.FileSystem.Watcher
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Threading.Overlapped
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.Options
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.Logging
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.Logging.Abstractions
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.Logging.EventLog
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.Logging.Configuration
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.Options.ConfigurationExtensions
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.Logging.Console
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Text.Json
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.Logging.Debug
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.Logging.EventSource
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Serilog.Extensions.Logging
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Serilog.Sinks.ApplicationInsights
Assembly Version: 4.0.0.0
Win32 Version: n/a
CodeBase:

Serilog.Enrichers.Sensitive
Assembly Version: 1.7.3.0
Win32 Version: n/a
CodeBase:

System.Text.RegularExpressions
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Reflection.Emit.ILGeneration
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Reflection.Primitives
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Private.Xml.Linq
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Private.Xml
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

PbiExplorer.BestPracticeAnalyzer
Assembly Version: 0.7.2.0
Win32 Version: n/a
CodeBase:

System.ObjectModel
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Newtonsoft.Json
Assembly Version: 13.0.0.0
Win32 Version: n/a
CodeBase:

System.Runtime.Serialization.Formatters
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Linq.Expressions
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Runtime.Numerics
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Runtime.Serialization.Primitives
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Data.Common
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Xml.ReaderWriter
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.ComponentModel.TypeConverter
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

PbiTools.ReportModel
Assembly Version: 0.7.2.0
Win32 Version: n/a
CodeBase:

System.Memory
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Anonymously Hosted DynamicMethods Assembly
Assembly Version: 0.0.0.0
Win32 Version: n/a
CodeBase:

System.Resources.Extensions
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

mscorlib
Assembly Version: 4.0.0.0
Win32 Version: n/a
CodeBase:

System.Collections.NonGeneric
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

DevExpress.Drawing.v23.1
Assembly Version: 23.1.6.0
Win32 Version: n/a
CodeBase:

System.Threading.Thread
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Configuration.ConfigurationManager
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Diagnostics.Process
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Security.Cryptography
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Net.WebClient
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.ComponentModel.EventBasedAsync
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System
Assembly Version: 4.0.0.0
Win32 Version: n/a
CodeBase:

DevExpress.Data.Desktop.v23.1
Assembly Version: 23.1.6.0
Win32 Version: n/a
CodeBase:

Microsoft.Win32.SystemEvents
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.IO.Compression
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Win32.Registry
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

PbiExplorer.Shared
Assembly Version: 0.7.2.0
Win32 Version: n/a
CodeBase:

Accessibility
Assembly Version: 4.0.0.0
Win32 Version: n/a
CodeBase:

DevExpress.XtraLayout.v23.1
Assembly Version: 23.1.6.0
Win32 Version: n/a
CodeBase:

DevExpress.XtraEditors.v23.1
Assembly Version: 23.1.6.0
Win32 Version: n/a
CodeBase:

DevExpress.Printing.v23.1.Core
Assembly Version: 23.1.6.0
Win32 Version: n/a
CodeBase:

DevExpress.XtraTreeList.v23.1
Assembly Version: 23.1.6.0
Win32 Version: n/a
CodeBase:

Microsoft.Web.WebView2.WinForms
Assembly Version: 1.0.2088.41
Win32 Version: n/a
CodeBase:

Microsoft.Web.WebView2.Core
Assembly Version: 1.0.2088.41
Win32 Version: n/a
CodeBase:

DevExpress.XtraVerticalGrid.v23.1
Assembly Version: 23.1.6.0
Win32 Version: n/a
CodeBase:

System.Diagnostics.StackTrace
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Numerics.Vectors
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.ComponentModel.Annotations
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

DevExpress.XtraBars.v23.1
Assembly Version: 23.1.6.0
Win32 Version: n/a
CodeBase:

System.Runtime.Loader
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Net.Http
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Net.Primitives
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Net.Security
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Net.Quic
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Net.Sockets
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Win32.Primitives
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Net.NameResolution
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Threading.ThreadPool
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Security.Principal.Windows
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Security.Claims
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Newtonsoft.Json.Schema
Assembly Version: 3.0.0.0
Win32 Version: n/a
CodeBase:

System.Windows.Extensions
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.IO.Packaging
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Reflection.Metadata
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Collections.Immutable
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Net.NetworkInformation
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Linq.Queryable
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Linq.Dynamic.Core
Assembly Version: 1.3.5.0
Win32 Version: n/a
CodeBase:

System.IO.FileSystem.DriveInfo
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Resources.Writer
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Xml.XmlSerializer
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Diagnostics.EventLog
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Console
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Xml.XDocument
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Reflection.Emit.Lightweight
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Formats.Asn1
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Net.Requests
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

WindowsBase
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Security.AccessControl
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

DevExpress.Sparkline.v23.1.Core
Assembly Version: 23.1.6.0
Win32 Version: n/a
CodeBase:

System.ServiceModel.Primitives
Assembly Version: 4.10.2.0
Win32 Version: n/a
CodeBase:

System.Private.ServiceModel
Assembly Version: 4.10.2.0
Win32 Version: n/a
CodeBase:

DevExpress.Pdf.v23.1.Core
Assembly Version: 23.1.6.0
Win32 Version: n/a
CodeBase:

System.Threading.Tasks
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Drawing
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

Microsoft.Extensions.FileSystemGlobbing
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Text.Encodings.Web
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

System.Runtime.Intrinsics
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

LibGit2Sharp
Assembly Version: 0.27.0.0
Win32 Version: n/a
CodeBase:

System.Runtime.InteropServices.RuntimeInformation
Assembly Version: 7.0.0.0
Win32 Version: n/a
CodeBase:

PbiExplorer.Entities
Assembly Version: 0.7.2.0
Win32 Version: n/a
CodeBase:

************** JIT Debugging **************

PBI Explorer

0.7.2

Power BI

Desktop Version: 2.124.2028.0 64-bit (December 2023)

Windows

Windows 11 Enterprise

Steps to reproduce the behavior

Whilst one file has been open to compare to, click the link to select the 2nd file - the message pops up after the file to open is selected.
Continuing shows the page outlines and pages list, however no comparison data shows for either model.

Additional context

Windows 11 Enterprise

Screenshots

No response

Anything else ?

No response

Same bug here, the only difference is the report mode – in my case both reports are in live connection to a PBI dataset in PBI Premium workspace.