Chicos
Tengo un panel que ha estado funcionando bastante bien durante varios meses, y de vez en cuando agrego un nuevo gráfico o un KPI. Desde hace un par de días, he estado tratando de actualizar la información deuna base de datos SQL sin éxito. El proceso de actualización se interrumpe y el mensaje que recibí de Power BI es 'Microsoft.Mashup.Evaluator.MessageBasedOutputStream+BinaryChunkMessage'. Lo intenté varias veces sin éxito. Luego actualicé una ruta de Excel que es una parte del panel y en la HD local y con el mismo resultado exacto y mensaje de error. Se adjunta el mensaje de error completo.
ObjectCacheSessions/Data/CacheStats/Size {"Start":"2021-08-04T00:59:04.3605691Z","Action":"ObjectCacheSessions/Data/CacheStats/Size","entryCount":"1","totalSize":"24","ProductVersion":"2.95.983.0 (21.07)","ActivityId":"00000000-0000-0000-0000-00000000000","Process":"Microsoft.Mashup.Container.NetFX45","Pid":488,"Tid":1,"Duration":"00:00:00.0010680"}
ObjectCacheSessions/Data/CacheStats/Access {"Start":"2021-08-04T00:59:04.3636464Z","Action":"ObjectCacheSessions/Data/CacheStats/Access","hits":"0","requests":"1","hitrate":"0","ProductVersion":"2.95.983.0 (21.07)","ActivityId":"00000000-0000-0000-0000-00000000000","Process":"Microsoft.Mashup.Container.NetFX45","Pid":488,"Tid":1,"Duration":"00:00:00.0000420"}
SimpleDocumentEvaluator/GetResult/Compile {"Start":"2021-08-04T00:59:04.9412118Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"20100","PartitionKey":"Section1/TABLA 2/Columnas con nombre cambiado","Expression":"let _849ff41670ee4073bf55ee68c0b0d46e_env = let DatabaseObject.From = (v) => if (v is function or v is action) then v else Table.FromValue(v) in Value.ReplaceType([#"TABLA 2" = DatabaseObject.From(#"TABLA 2")], type [#"TABLA 2" = Value.Type(DatabaseObject.From(#"TABLA 2"))]) in Table.FromValue(let __AS_Query__ = #"TABLA 2",n__AS_Table__ = Table.FromValue(__AS_Query__),n__AS_Compact__ = Table.RemoveColumns(__AS_Table__, Table.ColumnsOfType(__AS_Table__, { type table, type record, type list })),n__AS_Effective__ = Table.TransformColumnNames(__AS_Compact__, Text.Clean),n__M = #shared[[List.ConformToPageReader],[Graph.Nodes],[Value.Lineage]]?,n__AS_TransformClassification__ = (value) => Value.ReplaceType(Table.Distinct(List.Accumulate(__M[Graph.Nodes](__M[Value.Lineage](value)), #table({"ColumnName", "LabelId"}, {}), (current, node) => Table.Combine({current, Table.SelectColumns(Table.ExpandRecordColumn(Table.SelectRows(Value.Traits(node), each ([Provider] = "SQL" or [Provider] = "MicrosoftInformationProtection") and [Identifier] = "Classification"), "Value", {"LabelId"}), {"ColumnName", "LabelId"}, MissingField.UseNull)}))), escriba table [ColumnName=nullable text, LabelId = text]),n__AS_WithClassification__ = __M[List.ConformToPageReader]({__AS_Effective__, __AS_TransformClassification__}),n__AS_Result__ = if __M[List.ConformToPageReader] = null then __AS_Effective__ else __AS_WithClassification__nin __AS_Result__)","ProductVersion":"2.95.983.0 (21.07)","ActivityId":"3a0596cc-40e4-47b9-86a2-e6ab1e09c308","Process":"Microsoft.Mashup.Container.NetFX45","Pid":488,"Tid":1,"Duration":" 00:00:02.0576018"}
SimpleDocumentEvaluator/GetResult/Evaluate {"Start":"2021-08-04T00:59:06.9988432Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"20100","PartitionKey":"Section1/TABLA 2/Columnas con nombre cambiado","ProductVersion":"2.95.983.0 (21.07)","ActivityId":"3a0596cc-40e4-47b9-86a2-e6ab1e09c308","Process":"Microsoft.Mashup.Container.NetFX45","Pid":488,"Tid":1,"Duration":"00:00:00.0301829"}
SimpleDocumentEvaluator/GetResult<IDataReaderSource> {"Start":"2021-08-04T00:59:04.8902158Z","Action":"SimpleDocumentEvaluator/GetResult<IDataReaderSource>","HostProcessId":"20100","PartitionKey":"Section1/TABLA 2/Columnas con nombre cambiado","PageRowCount1":"1786","ProductVersion ":"2.95.983.0 (21.07)","ActivityId":"3a0596cc-40e4-47b9-86a2-e6ab1e09c308","Process":"Microsoft.Mashup.Container.NetFX45","Pid":488,"Tid":1,"Duration":"00:00:04.2859227"}
FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Engine.Interface.IDataReaderSource> {"Start":"2021-08-04T00:59:04.6057909Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Engine.Interface.IDataReaderSource>","HostProcessId":"20100","ProductVersion":"2.2.95.983.0 (21.07)","ActivityId":"3a0596cc-40e4-47b9-86a2-e6ab1e09c308","Process":"Microsoft.Mashup.Container.NetFX45","Pid":488,"Tid":1,"Duration":"00:00:02.4621217"}
SimpleDocumentEvaluator/GetResult/Compile {"Start":"2021-08-04T00:59:09.4209663Z","Action":"SimpleDocumentEvaluator/GetResult/Compile","HostProcessId":"20100","PartitionKey":"Section1/Gerencia/Tipo cambiado","Expression":"let _849ff41670ee4073bf55ee68c0b0d46e_env = let DatabaseObject.From = (v) => if (v is function or v is action) then v else Table.FromValue(v) in Value.ReplaceType([Gerencia = DatabaseObject.From(Gerencia)], type [Gerencia = Value.Type(DatabaseObject.From(Gerencia))]) in Table.FromValue(let __AS_Query__ = Gerencia,n__AS_Table__ = Table.FromValue(__AS_Query__),n__AS_Compact__ = Table.RemoveColumns(__AS_Table__, Table.ColumnsOfType(__AS_Table__, { type table, type record, type list })),n__AS_Effective__ = Table.TransformColumnNames(__AS_Compact__, Text.Clean),n__M = #shared[[List.ConformToPageReader],[Graph.Nodes],[Value.Lineage]]?,n__AS_TransformClassification__ = (value) => Value.ReplaceType(Table.Distinct( List.Accumulate(__M[Graph.Nodes](__M[Value.Lineage](value)), #table({"ColumnName", "LabelId"}, {}), (current, node) => Table.Combine({current, Table.SelectColumns(Table.ExpandRecordColumn(Table.SelectRows(Value.Traits(node), each ([Provider] = "SQL" or [Provider] = "MicrosoftInformationProtection") and [Identifier] = "Classification"), "Value", {"LabelId"}), {"ColumnName", "LabelId"}, MissingField.UseNull)}))), escriba table [ColumnName=nullable text, LabelId = text]),n__AS_WithClassification__ = __M[List.ConformToPageReader]({__AS_Effective__, __AS_TransformClassification__}),n__AS_Result__ = if __M[List.ConformToPageReader] = null then __AS_Effective__ else __AS_WithClassification__nin __AS_Result__)","ProductVersion":"2.95.983.0 (21.07)","ActivityId":"3a0596cc-40e4-47b9-86a2-e6ab1e09c308","Process":"Microsoft.Mashup.Container.NetFX45","Pid":488,"Tid":1,"Duration":"00:00:00.0085532"}
SimpleDocumentEvaluator/GetResult/Evaluate {"Start":"2021-08-04T00:59:09.4295530Z","Action":"SimpleDocumentEvaluator/GetResult/Evaluate","HostProcessId":"20100","PartitionKey":"Section1/Gerencia/Tipo cambiado","ProductVersion":"2.95.983.0 (21.07)","ActivityId":"3a0596cc-40e4-47b9-86a2-e6ab1e09c308","Process":"Microsoft.Mashup.Container.NetFX45","Pid":488,"Tid":1,"Duration":"00:00:00.0001135"}
SimpleDocumentEvaluator/GetResult<IDataReaderSource> {"Start":"2021-08-04T00:59:09.4209585Z","Action":"SimpleDocumentEvaluator/GetResult<IDataReaderSource>","HostProcessId":"20100","PartitionKey":"Section1/Gerencia/Tipo cambiado","PageRowCount1":"46","ProductVersion":"22.95.983.0 (21.07)","ActivityId":"3a0596cc-40e4-47b9-86a2-e6ab1e09c308","Process":"Microsoft.Mashup.Container.NetFX45","Pid":488,"Tid":1,"Duration":"00:00:00.0549937"}
FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Engine.Interface.IDataReaderSource> {"Start":"2021-08-04T00:59:09.4201832Z","Action":"FirewallDocumentEvaluator/GetResult<Microsoft.Mashup.Engine.Interface.IDataReaderSource>","HostProcessId":"20100","ProductVersion":"2.2.FirewallDocumentevaluator/GetResult 95.983.0 (21.07)","ActivityId":"3a0596cc-40e4-47b9-86a2-e6ab1e09c308","Process":"Microsoft.Mashup.Container.NetFX45","Pid":488,"Tid":1,"Duration":"00:00:00.0101728"}
Cualquier consejo para este asunto? Muchas gracias, saludos,
Abevann
