La referencia de objeto no establecida en una instancia de un error de objeto al cargar aplicar cambios

[sheetalshettiga]

Estoy recibiendo el error llamado Referencia de objeto no establecido en una instancia de un objeto en aplicar cambios

a continuación está el mensaje que me han pegado.

¿cuál puede ser el problema?

Tipo de comentarios:
Frown (Error)

Mensaje de error:
Referencia de objeto no establecida en una instancia de un objeto. Mensaje de seguimiento de pila:
Referencia de objeto no establecida en una instancia de un objeto.

PowerBINonFatalError:
"AppName":"PBIDesktop","AppVersion":"2.87.762.0","ModuleName":"Microsoft.PowerBI.Modeler.dll","Component":"Microsoft.PowerBI.Modeler.DateTableSubsystem","Error":"System.NullReferenceException","MethodDef":"CreateLocalDateTable","ErrorOffset":"136"

Registros de seguimiento de instantáneas:
C:'Usuarios'sheetals'AppData'Local'Microsoft'Power BI Desktop'FrownSnapShota9be32f5-17bf-4abd-a1fb-d33a3be74ae4.zip

Modo predeterminado del modelo:
Importación

Versión del modelo:
PowerBI_V3

Está habilitado el informe de modelos V3:
Verdad

Registros de seguimiento de rendimiento:
C:'Usuarios''sheetals''AppData'Local'Microsoft'Power BI Desktop'PerformanceTraces.zip

Funciones de vista previa habilitadas:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_NewWebTableInference
PBI_qnaLiveConnect
PBI_v3ModelsPreview

Funciones de vista previa desactivadas:
PBI_JsonTableInference
PBI_ImportTextByExample
PBI_ExcelTableInference
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_narrativeTextBox
PBI_dynamicParameters
PBI_anomalyDetection
PBI_newFieldList

Opciones de DirectQuery deshabilitadas:
TreatHanaAsRelationalSource

Nube:
GlobalCloud

ModelChangeStartingStackTrace:
en System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)
a System.Environment.get_StackTrace()
en Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.RunExtendedModelChangeAsync(Action'1 extendedModelChange, ModelingSession modelingSession, ModelingMashupDocument mashupDocument, IModelAuthoringChangeScopeProvider changeScopeProvider, Boolean roleChangesImpactQueries, IRefreshPolicyUpdater refreshPolicyUpdater, CancellationToken cancellationToken)
en Microsoft.PowerBI.Modeling.Engine.Loader.PowerQueryToModelLoader.PerformLoadInternal(IRelationshipLoader relationshipLoader, IModelAuthoringChangeScopeProvider authoringChangeScopeProvider, IModelingQueryServices queryServices, Action'1 beforeSchemaSyncCallback, Action'1 afterSchemaSyncCallback, IRefreshPolicyUpdater refreshUpdater, Boolean skipImpactAnalysisWarning)
en Microsoft.PowerBI.Modeling.Engine.Loader.PowerQueryToModelLoader.<>c__DisplayClass18_0.<PerformLoadAsync>b__1()
en System.Threading.Tasks.Task'1.InnerInvoke()
en System.Threading.Tasks.Task.Execute()
en System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
en System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
en System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)
en System.Threading.ThreadPoolWorkQueue.Dispatch()

PowerBIUserFeedbackServices_IsReported:
Verdad

Fórmulas:

sección Sección1;

compartido "ORDER_ITEMS" - dejar que
"Origen" - Oracle.Database("(DESCRIPTION-(ADDRESS-(PROTOCOL-TCP)(HOST-localhost)(PORT-1521))(CONNECT_DATA-(SERVICE_NAME-orcl))", [HierarchicalNavigation-true ]),
OT á "Origen" ,[Esquema "OT"]-[Datos],
"ORDER_ITEMS1" - OT -[Nombre"ORDER_ITEMS"]-[Datos],
"Consultas combinadas ORDER_ITEMS_ORDER_ID9" , Table.NestedJoin('"ORDER_ITEMS1", ''ORDER_ID'', 'ORDERS', '''ORDER_ID''',', 'ORDERS', 'JoinKind.Inner'),
"Pedidos expandidos 9" - Tabla.ExpandTableColumn('"Consultas combinadas ORDER_ITEMS_ORDER_ID9", "ORDERS", '"ORDER_ID","CUSTOMER_ID","STATUS","SALESMAN_ID","ORDER_DATE"','ORDER_ID (ORDERS)","CUSTOMER_ID","STATUS","SALESMAN_ID"","ORDER_DATE"),
"Consultas combinadas ORDER_ITEMS_CUSTOMER_ID30" - Table.NestedJoin('"Pedidos expandidos 9", ''CUSTOMER_ID'', CLIENTES, 'CUSTOMER_ID'',''CLIENTES', 'JoinKind.Inner'),
"Clientes expandidos 30" - Table.ExpandTableColumn('"Consultas combinadas ORDER_ITEMS_CUSTOMER_ID30", "CLIENTES", "CUSTOMER_ID","NOMBRE","ADDRESS","WEBSITE","CREDIT_LIMIT"',''CUSTOMER_ID '(CUSTOMERS)","NAME","ADDRESS","WEBSITE","CREDIT_LIMIT""),
"Consultas combinadas ORDER_ITEMS_CUSTOMER_ID2" - Table.NestedJoin('"Expanded CUSTOMERS 30", '"CUSTOMER_ID"', CONTACTOS, ''CUSTOMER_ID'', "CONTACTS", JoinKind.Inner),
"Contactos expandidos 2" - Table.ExpandTableColumn("ORDER_ITEMS_CUSTOMER_ID2 de consultas combinadas", "CONTACTS", "CONTACT_ID","FIRST_NAME","LAST_NAME","EMAIL","PHONE","CUSTOMER_ID","CONTACT_ID","FIRST_NAME","LAST_NAME","EMAIL","PHONE","CUSTOMER_ID")
En
"CONTACTOS expandidos 2";

compartido "ORDERS" - dejar que
"Origen" - Oracle.Database("(DESCRIPTION-(ADDRESS-(PROTOCOL-TCP)(HOST-localhost)(PORT-1521))(CONNECT_DATA-(SERVICE_NAME-orcl))", [HierarchicalNavigation-true ]),
OT á "Origen" ,[Esquema "OT"]-[Datos],
"ORDERS1" á OT-[Nombre-"PEDIDOS"]-[Datos]
En
"ORDERS1";

compartido "CLIENTES" - dejar que
"Origen" - Oracle.Database("(DESCRIPTION-(ADDRESS-(PROTOCOL-TCP)(HOST-localhost)(PORT-1521))(CONNECT_DATA-(SERVICE_NAME-orcl))", [HierarchicalNavigation-true ]),
OT á "Origen" ,[Esquema "OT"]-[Datos],
"CUSTOMERS1" á OT-[Nombre-"CLIENTES"]-[Datos]
En
"CLIENTES1";

"CONTACTOS" compartidos - dejar que
"Origen" - Oracle.Database("(DESCRIPTION-(ADDRESS-(PROTOCOL-TCP)(HOST-localhost)(PORT-1521))(CONNECT_DATA-(SERVICE_NAME-orcl))", [HierarchicalNavigation-true ]),
OT á "Origen" ,[Esquema "OT"]-[Datos],
"CONTACTOS1" - OT -[Nombre"CONTACTOS"]-[Datos]
En
"CONTACTOS1";

"PRODUCTOS" compartidos - dejar que
"Origen" - Oracle.Database("(DESCRIPTION-(ADDRESS-(PROTOCOL-TCP)(HOST-localhost)(PORT-1521))(CONNECT_DATA-(SERVICE_NAME-orcl))", [HierarchicalNavigation-true ]),
OT á "Origen" ,[Esquema "OT"]-[Datos],
"PRODUCTS1" á OT-[Nombre-"PRODUCTOS"]-[Datos]
En
"PRODUCTS1";

compartido "PRODUCT_CATEGORIES" - dejar que
"Origen" - Oracle.Database("(DESCRIPTION-(ADDRESS-(PROTOCOL-TCP)(HOST-localhost)(PORT-1521))(CONNECT_DATA-(SERVICE_NAME-orcl))", [HierarchicalNavigation-true ]),
OT á "Origen" ,[Esquema "OT"]-[Datos],
"PRODUCT_CATEGORIES1" - OT -[Nombre"PRODUCT_CATEGORIES"]-[Datos]
En
"PRODUCT_CATEGORIES1";

[amitchandak]

@sheetalshettiga, revisé algunos problemas del pasado. Sucede cuando el parche de Windows está pendiente o pocos usuarios se enfrentan en la nueva actualización.

Compruebe si hay alguna actualización de Windows pendiente, instálelala.

Además, Asegúrese de rae en el último vserion de power bi. Si se ha instalado recientemente. Vuelva a instalarlo e inténtelo.

[sheetalshettiga]

@amitchandak todo está al día todavía teniendo el mismo problema

[sheetalshettiga]

{
"editEntity":
"entity": "ORDER_ITEMS",
"mashupExpression": "let\r\n #\"Source\" = Oracle.Database(\"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)))\", [HierarchicalNavigation=true ]),\r\n OT = #\"Source\"{[Schema=\"OT\"]}[Data],\r\n #\"ORDER_ITEMS1\" = OT{[Name=\"ORDER_ITEMS\"]}[Data],\r\n #\"Merged Queries ORDER_ITEMS_ORDER_ID9\" = Table.NestedJoin(#\"ORDER_ITEMS1\", {\"ORDER_ID\"}, ORDERS, {\"ORDER_ID\"}, \"ORDERS\", JoinKind.Inner),\r\n #\"Expanded ORDERS 9\" = Table.ExpandTableColumn(#\"Merged Queries ORDER_ITEMS_ORDER_ID9\", \"ORDERS\", {\"ORDER_ID\",\"CUSTOMER_ID\",\"STATUS\",\"SALESMAN_ID\",\"ORDER_DATE\"},{\"ORDER_ID (ORDERS)\",\"CUSTOMER_ID\",\"STATUS\",\"SALESMAN_ID\",\"ORDER_DATE\"}),\r\n #\"Merged Queries ORDER_ITEMS_CUSTOMER_ID30\" = Table.NestedJoin(#\"Expanded ORDERS 9\", {\"CUSTOMER_ID\"}, CUSTOMERS, {\"CUSTOMER_ID\"}, \"CUSTOMERS\", JoinKind.Inner),\r\n #\"Expanded CUSTOMERS 30\" = Table.ExpandTableColumn(#\"Merged Queries ORDER_ITEMS_CUSTOMER_ID30\", \"CUSTOMERS\", {\"CUSTOMER_ID\" "NAME","ADDRESS","WEBSITE","CREDIT_LIMIT","CUSTOMER_ID (CLIENTES)","NOMBRE","ADDRESS","WEBSITE","CREDIT_LIMIT"-"-""CUSTOMER_ID combinadas ORDER_ITEMS_CUSTOMER_ID2", "Nombre","ADDRESS","ADDRESS","WEBSITE","CREDIT_LIMIT",""ORDER_ITEMS_CUSTOMER_ID2 combinadas" "CUSTOMER_ID", CONTACTOS, "CUSTOMER_ID", "CONTACTOS", JoinKind.Inner),"CONTACTOS expandidos 2" - Tabla.ExpandTableColumn('Consultas combinadas ORDER_ITEMS_CUSTOMER_ID2',"CONTACTOS", "CONTACT_ID",""FIRST_NAME","LAST_NAME","EMAIL","PHONE","FIRST_NAME","LAST_NAME","EMAIL","PHONE",""PHONE","FIRST_NAME","LAST_NAME","EMAIL","PHONE","PHONE","FIRST_NAME","LAST_NAME","EMAIL","PHONE","FIRST_NAME",""LAST_NAME","EMAIL","PHONE",""CUSTOMER_ID,","CONTACT_ID","FIRST_NAME","LAST_NAME","EMAIL","PHONE","CUSTOMER_ID (CONTACTOS)"-"-n-n-"CONTACTOS expandidos 2"",
"dataSourceName": null,
"connectionString": null,
"commandText": null
}
},
{
"editEntity":
"entity": "PEDIDOS",
"mashupExpression": "let-r-n-"Origen" - Oracle.Database(-"(DESCRIPTION-(ADDRESS-(PROTOCOL-TCP)(HOST-localhost)(PORT-1521))(CONNECT_DATA-(SERVICE_NAME-orcl)))", [Navegación jerárquica,true ]), "OT" o "Origen""[Esquema"OT"][Datos],""PEDIDOS1"" , "OT" , ""Nombre"[Datos],[Datos],
"dataSourceName": null,
"connectionString": null,
"commandText": null
}
},
{
"editEntity":
"entidad": "CLIENTES",
"mashupExpression": "let-r-n-"Origen" - Oracle.Database(-"(DESCRIPTION-(ADDRESS-(PROTOCOL-TCP)(HOST-localhost)(PORT-1521))(CONNECT_DATA-(SERVICE_NAME-orcl)))", [Navegación jerárquica,true ]), "O"OT" " "Origen" , [Esquema " "OT ""[Datos], "CLIENTES1" , "CLIENTES" , "[Nombre" "CLIENTES"], [Datos], "Datos", "Clientes1",
"dataSourceName": null,
"connectionString": null,
"commandText": null
}
},
{
"editEntity":
"entity": "CONTACTOS",
"mashupExpression": "let-r-n-"Origen" - Oracle.Database(-"(DESCRIPTION-(ADDRESS-(PROTOCOL-TCP)(HOST-localhost)(PORT-1521))(CONNECT_DATA-(SERVICE_NAME-orcl)))", [Navegación jerárquica,true ]), "OT" o "Origen""[Esquema"OT"][Datos],"CONTACTOS1"", ""[Nombre",",","[Nombre"","Contactos"],[Datos],
"dataSourceName": null,
"connectionString": null,
"commandText": null
}
},
{
"editEntity":
"entidad": "PRODUCTS",
"mashupExpression": "let-r-n-"Origen" - Oracle.Database(-"(DESCRIPTION-(ADDRESS-(PROTOCOL-TCP)(HOST-localhost)(PORT-1521))(CONNECT_DATA-(SERVICE_NAME-orcl)))", [Navegación jerárquica,true ]), "OT" o "Origen""[Esquema"OT"][Datos],"PRODUCTS1"" , "OT"[Nombre"
"dataSourceName": null,
"connectionString": null,
"commandText": null
}
},
{
"editEntity":
"entity": "PRODUCT_CATEGORIES",
"mashupExpression": "let-r-n-"Origen" - Oracle.Database(-"(DESCRIPTION-(ADDRESS-(PROTOCOL-TCP)(HOST-localhost)(PORT-1521))(CONNECT_DATA-(SERVICE_NAME-orcl)))", [Navegación jerárquica,verdadero ]), "OT" o "Origen""[Esquema"OT"],[Datos],"PRODUCT_CATEGORIES1"", OT,[Nombre","PRODUCT_CATEGORIES"],[Datos], r,nin, "PRODUCT_CATEGORIES1",
"dataSourceName": null,
"connectionString": null,
"commandText": null
}
}