Error loading data from ODBC

[melpbi]

Hi,

I'm getting this error when loading data from an ODBC. Could someone help me with this issue? I don't know what is causing this...

Thank you!

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:
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.HtmlRenderers.ColumnProfiling.ColumnQualityDetailsRenderer.GetListItemViewModels(ColumnQualityViewModel viewModel)
at Microsoft.Mashup.Client.UI.Shared.HtmlRenderers.ColumnProfiling.ColumnQualityDetailsRenderer.Render(IHtmlTextWriter writer, ColumnQualityViewModel viewModel)
at Microsoft.Mashup.Client.UI.Shared.HtmlRenderers.ColumnProfiling.ColumnQualityRenderer.Render(IHtmlTextWriter writer, ColumnQualityViewModel columnQualityViewModel, Boolean renderDetails)
at Microsoft.Mashup.Client.UI.Shared.HtmlRenderers.ColumnProfiling.ColumnProfileRenderer.RenderColumnQuality(IHtmlTextWriter writer, IReadonlyColumnProfile columnProfile, Int32 columnWidth, Boolean renderColumnQualityDetails)
at Microsoft.Mashup.Client.UI.Shared.HtmlRenderers.ColumnProfiling.ColumnProfileRenderer.Render(IHtmlTextWriter writer, Int32 columnIndex, IReadonlyColumnProfile columnProfile, Int32 columnOffset, Int32 columnWidth, Boolean renderColumnQualityDetails, Boolean renderColumnDistribution)
at Microsoft.Mashup.Client.UI.Shared.HtmlControls.Results.Table.HtmlTableRenderer.RenderColumnProfiles(IHtmlTextWriter writer, Range columnRange)
at Microsoft.Mashup.Client.UI.Shared.PageManager.HtmlTablePageRenderer.RenderColumnProfilePage(IHtmlTextWriter writer, PageColumn pageColumn, Int32 pageColumnIndex)
at Microsoft.Mashup.Client.UI.Shared.PageManager.HtmlGridPageRenderer.ExecuteWithHtmlWriter(Action`1 renderAction)
at Microsoft.Mashup.Client.UI.Shared.HtmlControls.Results.Grid.GridResultHtmlControl.JsPageContainerWrapper.AppendPages(PageHtmlProvider pageHtmlProvider, IEnumerable`1 indexesOfPagesToAppend)
at Microsoft.Mashup.Client.UI.Shared.HtmlControls.Results.Grid.GridResultHtmlControl.JsPageContainerWrapper.UpdatePages(PageHtmlProvider pageHtmlProvider, IEnumerable`1 indexesOfPagesToRemove, IEnumerable`1 indexesOfPagesToAppend, IEnumerable`1 indexesOfPagesToPrepend)
at Microsoft.Mashup.Client.UI.Shared.HtmlControls.Results.Table.TableResultHtmlControl.RenderColumnProfilePages(HtmlGridPageRenderer gridPageRenderer, GridPages gridPagesToRender, GridPageDiffs gridPageDiffs)
at Microsoft.Mashup.Client.UI.Shared.HtmlControls.Results.Table.TableResultHtmlControl.OnProfileCompleted(Object sender, ProfileComputedEventArgs eventArgs)
at System.EventHandler`1.Invoke(Object sender, TEventArgs e)
at Microsoft.Mashup.Host.Models.EventHandlerExtensions.RaiseEvent[TEventArgs](EventHandler`1 handler, Object sender, TEventArgs args)
at Microsoft.Mashup.Client.UI.Shared.Models.Profiling.TableProfileEvaluator.TableProfileEvaluationRunner.OnEvaluationCompleted(ITableProfileEvaluation currentEvaluation, IEnumerable`1 computedColumnProfiles)
at Microsoft.Mashup.Client.UI.Shared.Models.Profiling.Evaluations.TableProfileEvaluationBase.OnEvaluationCompleted(PreviewReference previewReference, Action`1 completedCallback)
at Microsoft.Mashup.Host.Document.Evaluation.PreviewEvaluationQueue.<>c__DisplayClass48_0.<OnPreviewComplete>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

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 Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
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.Delegate.DynamicInvokeImpl(Object[] args)
at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
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:
Empty

Snapshot Trace Logs:
C:\Users\User1\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot742094185.zip

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

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_NewWebTableInference
PBI_showIncrementalRefreshPolicy
PBI_qnaLiveConnect
PBI_userFavoriteResourcePackagesEnabled

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

Formulas:

section Section1;

shared #"Table1" = let
Source = Odbc.Query("dsn=abcd", "select * from folder.Table1")
in
Source;

[v-qiuyu-msft]

Hi @melpbi,

Please go to ODBC tool, test the connection to see if there is any error. also you can connect to the same DSN with Excel to see if the same error occurs. 

Best Regards,
Qiuyun Yu

[melpbi]

Hello @v-qiuyu-msft,

Thank you for your kind reply.

The connection seems to be fine. I also have other reports connected to the same DSN and they work fine too :(.

Thanks,

Melpbi

[v-qiuyu-msft]

Hi @melpbi , 

Till now, it's hard to provide further support on forum side. I would suggest you create a support ticket to let engineers look into the issue on your side. 

Best Regards,
Qiuyun Yu

[melpbi]

Hi @v-qiuyu-msft,

Okay, thanks for the recommendation!