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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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.