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.
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";
@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.
{
"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
}
}
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |