While updating data from SQL or Excel, got and error and can't update data

[Abevann]

Guys,

I have a dashboard that has been working pretty good for several months, and once in a while add a new graph or a KPI. Since couple of days ago, I have been trying ti update the info froma SQL database without success. The update process is interrupted and the message that I got from Power BI is 'Microsoft.Mashup.Evaluator.MessageBasedOutputStream+BinaryChunkMessage'. I tried several times with no success. Then I updated an excel path which is a part of the dashboard and in the local HD and with the exact same result and error message. Attached the full error message.

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-000000000000","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-000000000000","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)}))), type 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.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)}))), type 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":"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.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.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"}

Any advise for this issue? Thanks a lot, regards,

Abevann

[v-rzhou-msft]

Hi @Abevann 

I find similar issue like yours, and one end user solved his issue by finding the duplicate value from Power BI Service.

If you have the data model published to the power bi service try refreshing it on the services and you should see what the problem is.

For reference: No handler was found for message type 'Microsoft.Mashup.Evaluator.MessageBasedOutputStream+BinaryChu

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Abevann · Accepted solution]

Hey Rico,

Thanks a lot. It solves itself next day... seems there was a bug in this release, and with the same procedure everything was ok.

Thanks, regards,

Abelardo

[lbendlin]

This doesn't look like a dashboard.  Do you mean a report you created on Power BI Desktop?  Have you published that to a workspace at any point? Or do you only use it on your PC?

[Abevann]

Hey Ibendlin,

It is a Power BI dashboard, and I was trying to update the database. Afortunatelly, It solves itself next day... seems there was a bug in this release, and with the same procedure everything was ok.

Thanks, regards,

Abelardo