Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

issue

Hi i'm facing some error

 

 

Feedback Type:
Frown (Error)

Timestamp:
2020-06-07T10:55:09.9303226Z

Local Time:
2020-06-07T16:25:09.9303226+05:30

Session ID:
1300c997-3aa3-4331-baaa-e73cb5d3191a

Release:
April 2020

Product Version:
2.80.5803.1061 (20.04) (x64)

Stack Trace:
at Microsoft.Mashup.Host.Models.Verify.NotNull[T](T value, String argumentName)
at Microsoft.Mashup.Client.UI.Shared.JsWrappers.JsKnockoutViewModel..ctor(IJsObject jsObject)
at Microsoft.Mashup.Client.UI.Shared.HtmlControls.QueryStatusBarHtmlControl.JsQueryStatusBarHtmlControlWrapper.get_ViewModel()
at Microsoft.PowerBI.Client.Windows.QueriesEditorWindow.OnQueryDiagnosticsStateChange(QueryDiagnosticsState queryDiagnosticsState)
at Microsoft.PowerBI.Client.Windows.QueriesEditorWindow.EnsureQueryDiagnosticsDisposal(Action action)
at Microsoft.PowerBI.Client.Windows.Diagnostics.QueryDiagnostics.<OnCancellation>b__34_0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.80.5803.1061","ModuleName":"Microsoft.Mashup.Client.UI.dll","Component":"Microsoft.Mashup.Client.UI.Shared.JsWrappers.JsKnockoutViewModel","Error":"System.ArgumentNullException","MethodDef":".ctor","ErrorOffset":"17"}

OS Version:
Microsoft Windows NT 10.0.18363.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 528040]

Peak Virtual Memory:
38.8 GB

Private Memory:
822 MB

Peak Working Set:
940 MB

IE Version:
11.836.18362.0

User ID:
55a255e1-6f63-4ef1-ae6e-166cd624edf2

Workbook Package Info:
1* - en-IN, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\Vaibhav Arora\Microsoft\Power BI Desktop Store App\FrownSnapShot869053365.zip

Model Default Mode:
Import

Model Version:
PowerBI_V1

Is Report V3 Models Enabled:
False

Enabled Preview Features:
PBI_showMinervaRibbon
PBI_showMinervaViewNavigator
PBI_hierarchicalSlicerCreation

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_NewWebTableInference
PBI_qnaLiveConnect
PQ_AIInsightsFunctionBrowser
PBI_inlineExplore
PBI_realTimeRefresh
PBI_v3ModelsPreview
PBI_decompositionTree
PBI_relativeTimeSlicer

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
125%

Supported Services:
Power BI

 

section Section1;

shared Customers = let
Source = DocumentDB.Contents("https://equitasbankproddb.documents.azure.com:443/", "ProgramDB", "Customers", [Query = "Select * from c where c.discriminator = ""customer"""]),
#"Expanded Document" = Table.ExpandRecordColumn(Source, "Document", {"pincode", "home_phone", "city", "last_name", "middle_name", "state", "customer_id", "first_name", "customercode", "email"}, {"Document.pincode", "Document.home_phone", "Document.city", "Document.last_name", "Document.middle_name", "Document.state", "Document.customer_id", "Document.first_name", "Document.customercode", "Document.email"})
in
#"Expanded Document";

shared Wallet = let
Source = DocumentDB.Contents("https://equitasbankproddb.documents.azure.com:443/", "ProgramDB"),
Customers1 = Source{[id="Customers"]}[Documents],
#"Expanded Document" = Table.ExpandRecordColumn(Customers1, "Document", {"discriminator", "customerCode", "campaignCode", "earningDetails", "code", "walletFor", "earnedValue", "avaliableValueToRedeem"}, {"Document.discriminator", "Document.customerCode", "Document.campaignCode", "Document.earningDetails", "Document.code", "Document.walletFor", "Document.earnedValue", "Document.avaliableValueToRedeem"}),
#"Filtered Rows" = Table.SelectRows(#"Expanded Document", each ([Document.discriminator] = "Wallet") and ([Document.walletFor] = "Customer")),
#"Merged Queries" = Table.NestedJoin(#"Filtered Rows", {"Document.code"}, Customers, {"Document.customercode"}, "Customers", JoinKind.LeftOuter),
#"Expanded Customers" = Table.ExpandTableColumn(#"Merged Queries", "Customers", {"Document.pincode", "Document.home_phone", "Document.city", "Document.last_name", "Document.middle_name", "Document.state", "Document.customer_id", "Document.first_name", "Document.customercode", "Document.email"}, {"Customers.Document.pincode", "Customers.Document.home_phone", "Customers.Document.city", "Customers.Document.last_name", "Customers.Document.middle_name", "Customers.Document.state", "Customers.Document.customer_id", "Customers.Document.first_name", "Customers.Document.customercode", "Customers.Document.email"})
in
#"Expanded Customers";

 

 

Status: New
Comments
v-chuncz-msft
Community Support

@nikita_1994 

 

I cannot reproduce the issue. Try the latest version of Power BI Desktop and create a support ticket for assistance if necessary.