Query execution failing with : Parameter name: Total sum of fractions doesn't equal 1. Fractions: 0,

[rameesr]

Feedback Type:
Frown (Error)

Error Message:
Expression should be true.
Parameter name: Total sum of fractions doesn't equal 1. Fractions: 0, 0, 0.

Stack Trace:
Error: Expression should be true.
Parameter name: Total sum of fractions doesn't equal 1. Fractions: 0, 0, 0.
at TableResultFlyoutManager.prototype.showFlyout (ms-pbi://pbi.microsoft.com/ts/Controls/Results/Table/TableResultColumnProfileFlyoutHandler.js:52:21)
at Anonymous function (ms-pbi://pbi.microsoft.com/ts/Flyout/FlyoutManager.js:68:17)
at Anonymous function (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.1.1.js:2:28218)
at j (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.1.1.js:2:26852)
at k.fireWith (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.1.1.js:2:27609)
at e[] (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.1.1.js:2:28632)
at Anonymous function (ms-pbi://pbi.microsoft.com/ts/Shared/HoverManager.js:23:17)
at wrappedCallback (ms-pbi://pbi.microsoft.com/ts/Shared/TrackedTimer.js:7:13)

Stack Trace Message:
Expression should be true.
Parameter name: Total sum of fractions doesn't equal 1. Fractions: 0, 0, 0.

Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.Mashup.Client.UI.Shared.JsExportWrapper.<>c__DisplayClass13_0.<InvokeMember>b__0()
at Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeHost(Func`1 invokeHost)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_0.<Main>b__1()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)

InnerException.Stack Trace Message:
Expression should be true.
Parameter name: Total sum of fractions doesn't equal 1. Fractions: 0, 0, 0.

InnerException.Stack Trace:
at Microsoft.Mashup.Host.Models.Verify.IsTrue(Boolean expression, String argumentName)
at Microsoft.Mashup.Client.UI.Shared.MathUtils.RoundFractionsToPrecisionEnsuringSumEqualsToOne(Nullable`1[] fractions, Int32 precision)
at Microsoft.Mashup.Client.UI.Shared.MathUtils.FormatAsIntegerPercentages(Nullable`1[] fractions)
at Microsoft.Mashup.Client.UI.Shared.Ux.Flyout.ColumnProfile.ColumnQualityFlyoutViewModel.JsonQualityBarFlyoutDetailsData..ctor(ColumnQualityFlyoutViewModel viewModel)
at Microsoft.Mashup.Client.UI.Shared.Ux.Flyout.ColumnProfile.ColumnQualityFlyoutViewModel.GetMainTemplateJsonViewModel()
at Microsoft.Mashup.Client.UI.Shared.Ux.Flyout.ColumnProfile.ColumnProfileFlyoutViewModel.JsonColumnProfileFlyoutViewModel..ctor(ColumnProfileFlyoutViewModel viewModel)
at Microsoft.Mashup.Client.UI.Shared.Ux.Flyout.ColumnProfile.ColumnProfileFlyout.UpdateViewModel(ColumnProfileFlyoutTarget target, IReadonlyColumnProfile columnProfile)
at Microsoft.Mashup.Client.UI.Shared.Ux.Flyout.ColumnProfile.ColumnProfileFlyout.Show(ColumnProfileFlyoutTarget target, Rectangle targetArea, FormOrientation[] orientations, FlyoutActivationEvent activationEvent)
at Microsoft.Mashup.Client.UI.Shared.HtmlControls.Results.Table.TableResultColumnProfileFlyoutHandler.Js_ShowColumnProfileFlyout(String jsonParamsString)

InnerException.Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e)
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.Mashup.Client.UI.Shared.JsExportWrapper.<>c__DisplayClass13_0.<InvokeMember>b__0()
at Microsoft.Mashup.Client.UI.Windows.JsErrorHandler.WrapInvokeHost(Func`1 invokeHost)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_0.<Main>b__1()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\rameesr\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot999582449.zip

Performance Trace Logs:
C:\Users\rameesr\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:
PBI_showIncrementalRefreshPolicy

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_NewWebTableInference
PBI_qnaLiveConnect
PBI_userFavoriteResourcePackagesEnabled
PBI_tenantOutOfBoxVisualsEnabled
PBI_personalVisualizationPaneEnabled

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
MSIT

Formulas:

section Section1;

shared Category = let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCikqTfVLTU8sySxLVYrVgQgE5BdnwgXcEnOKUZWARRBqYgE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Category = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Category", type text}})
in
#"Changed Type";

shared svsSummary_R_1 = let
Source =
let Source = Json.Document(Web.Contents("https://api.applicationinsights.io/v1/apps/666144f8-4fb0-4f11-8806-f8aa20d64aa1/query",
[Query=[#"query"="let customTime = datetime(2019-11-20);
let precision = 4;
customEvents | where timestamp > customTime and name contains ""Summary""
| extend Duration=toreal(customMeasurements.DurationInMillisecond),
PerformanceBucket=case(toreal(customMeasurements.DurationInMillisecond) < 250, ""<250ms"",
toreal(customMeasurements.DurationInMillisecond) between (250 .. 499), "" 250ms-500ms"",
toreal(customMeasurements.DurationInMillisecond) between (500 .. 999), "" 500ms-1s"",
toreal(customMeasurements.DurationInMillisecond) between (1000 .. 2999), "" 1s-3s"",
toreal(customMeasurements.DurationInMillisecond) between (3000 .. 6999), "" 3s-7s"",
toreal(customMeasurements.DurationInMillisecond) between (7000 .. 14999), "" 7s-15s"",
toreal(customMeasurements.DurationInMillisecond) between (15000 .. 29999), "" 15s-30s"",
toreal(customMeasurements.DurationInMillisecond) between (30000 .. 59999), "" 30s-1m"",
toreal(customMeasurements.DurationInMillisecond) between (60000 .. 119999), "" 1m-2m"",
toreal(customMeasurements.DurationInMillisecond) between (120000 .. 299999), "" 2m-5m"",
"" >5m""),
APIResponse=case(tostring(customDimensions.ResponseResult) == ""True"", ""Success"",
tostring(customDimensions.ResponseResult) == ""False"", ""Failure"", ""Unknown"")

| summarize Count=count(),
Pass=sum(toreal(customMeasurements.ValidationPassCount)), Hit=sum(toreal(customMeasurements.ValidationFailCount)), Warning=sum(toreal(customMeasurements.ValidationWarningCount)), Exception=sum(toreal(customMeasurements.ValidationExceptionCount)),
AvgDuration=avg(Duration), MaxDuration=max(Duration), MinDuration=min(Duration),
Words=sum(toint(customMeasurements.SourceTotalWordCount)), Chars=sum(toint(customMeasurements.SourceTotalCharCount)), Resources=sum(toreal(customMeasurements.ResourceCount)),
Opids=makeset(operation_Id)
by bin(timestamp, 1d)
, Tenant=tolower(customDimensions.Tenant), Project=tolower(customDimensions.Subtenant),
Events=name, ValidatorFilters=tostring(customDimensions.ValidatorType), Customer=tostring(customDimensions.RequestSource),
User=tostring(customDimensions.User), Profile=tostring(customDimensions.Profile), IrisVersion=tolower(customDimensions.IrisVersion), SourceCulture=tostring(customDimensions.SourceCulture), IrisStatusCode=toreal(customDimensions.StatusCode),
Slot=cloud_RoleName, Response=tostring(customDimensions.ResponseResult),
APIResponse, Culture=tostring(customDimensions.TargetCulture), PerformanceBucket
| extend PassPercentage=round((Pass/iff(Pass>Resources, Pass, Resources)),precision), FailPercentage=round((Hit/iff(Hit>Resources, Hit, Resources)), precision),
WarningPercentage=round((Warning/iff(Warning>Resources, Warning, Resources)), precision), ExceptionPercentage=round((Exception/iff(Exception>Resources, Exception, Resources)), precision),
Validationstatus=case(Hit > 0, ""Hit"",
Warning > 0, ""Warning"",
Exception > 0, ""Exception"",
Pass > 0, ""Pass"",
""NA"" ),
CurrentSlot=case(Slot == ""sharedvalidation-1-2"", ""Production"",
Slot == ""sharedvalidation-1-2-preproduction"", ""PreProduction"",
Slot == ""sharedvalidation-1-2-staging"", ""Staging"",
Slot == ""sharedvalidation-1-2-testing"", ""Testing"",
Slot == ""irisweb"", ""Production"",
Slot == ""irisweb-staging"", ""PreProduction"",
Slot == ""irisweb-testing"", ""Staging"",
Slot == ""irisweb-dev"", ""Testing"",
""NA""),
Validator=case(Events == ""SharedValidationServiceSummary"", ""SVS"",
Events == ""OnePolicheckSummary"", ""OnePolicheck"",
Events == ""IrisSummary"", ""IRIS"",
Events == ""LocVerSummary"", ""LocVer"",
Events == ""OneTermSummary"", ""OneTerm"",
""Others""),
Service=case(Events == ""SharedValidationServiceSummary"", ""SVSvc"",
Events == ""OnePolicheckServiceSummary"", ""OnePolicheckSvc"",
Events == ""IrisServiceSummary"", ""IRISSvc"",
Events == ""LocVerServiceSummary"", ""LocVerSvc"",
Events == ""OneTermServiceSummary"", ""OneTermSvc"",
""Others"")
| order by timestamp desc

[v-qiuyu-msft]

Hi @rameesr, 

Please go to Query Editor, click on each step of the query, check if there is any step has the issue. 

Also please run the latest Power BI desktop version 2.76.5678.782. 

Best Regards,
Qiuyun Yu

[lamysroe]

I am having the same issue after months of running a working report. This started yesterday after no changes to the report. The error appears on the first step which is Promoted Headers.

[dangelo1]

I am having the same issue after months of running a working report. This started this monday after no changes to the report. The error appears when I try to refresh the previe of the table. Also the preview says that the table is empty but if I reload it the data flows correctly.