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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Error: Microsoft.Mashup.Evaluator.MessageBasedOutputStream

Hi happens every time I change a source:

 

Feedback Type:
Frown (Error)

Timestamp:
2021-09-22T12:08:22.2955038Z

Local Time:
2021-09-22T14:08:22.2955038+02:00

Session ID:
812aa065-f08e-4a1d-ba34-0789d8d7cff9

Release:
August 2021

Product Version:
2.96.1061.0 (21.08) (x64)

Stack Trace:
Microsoft.Mashup.Host.Document.SerializedException
bei Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
bei Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
bei Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
bei Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
bei Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.TranslateCancelExceptions(Action action)
bei Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.IgnoreCancelExceptions(Action action)
bei Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Finish()
bei Microsoft.Mashup.Evaluator.Interface.IDataReaderSourceExtensions.<>c__DisplayClass1_0.<AfterDispose>b__0()
bei Microsoft.Mashup.Evaluator.Interface.NotifyingDataReaderSource.Dispose()
bei Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.Dispose[T](EvaluationResult2`1 result)
bei Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.<>c__DisplayClass10_0.<Complete>b__0()
bei Microsoft.Mashup.Evaluator.Interface.NotifyingDataReaderSource.Dispose()
bei Microsoft.Mashup.Evaluator.DocumentEvaluator.<>c__DisplayClass7_1`1.<BeginGetResult>b__1()
bei Microsoft.Mashup.Evaluator.Interface.NotifyingDataReaderSource.Dispose()
bei Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.Dispose[T](EvaluationResult2`1 result)
bei Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.<>c__DisplayClass10_0.<Complete>b__0()
bei Microsoft.Mashup.Evaluator.Interface.NotifyingDataReaderSource.Dispose()
bei Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.Dispose[T](EvaluationResult2`1 result)
bei Microsoft.Mashup.OleDbProvider.DataHost.MashupEvaluator.<>c__DisplayClass4_1.<Evaluate>b__1()
bei Microsoft.Mashup.Evaluator.Interface.NotifyingDataReaderSource.Dispose()
bei Microsoft.Mashup.Engine.Interface.Tracing.TracingDataReaderSource.Dispose()
bei Microsoft.Mashup.Evaluator.Interface.IDataReaderSourceExtensions.<>c__DisplayClass1_0.<AfterDispose>b__0()
bei Microsoft.Mashup.Evaluator.Interface.NotifyingDataReaderSource.Dispose()
bei Microsoft.Mashup.OleDbProvider.MashupCommandEvaluation.Dispose()
bei Microsoft.Mashup.OleDbProvider.TracingMultipleResults.Dispose()

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.96.1061.0","ModuleName":"","Component":"","Error":"Microsoft.Mashup.Host.Document.SerializedException - System.InvalidOperationException","MethodDef":"","ErrorOffset":""}

OS Version:
Microsoft Windows NT 10.0.19043.0 (x64 de-DE)

CLR Version:
4.7 or later [Release Number = 528372]

Peak Virtual Memory:
102 GB

Private Memory:
767 MB

Peak Working Set:
0.997 GB

IE Version:
11.789.19041.0

User ID:
9ed1a286-4e19-4988-b17d-28d0312bd1e8

Workbook Package Info:
1* - de-DE, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
Import

Model Version:
PowerBI_V3

Enabled Preview Features:
PBI_JsonTableInference
PBI_NewWebTableInference
PBI_ImportTextByExample
PBI_ExcelTableInference
PBI_rdlNativeVisual

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_dynamicParameters
PBI_enhancedTooltips

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Status: New
Comments
v-robertq-msft
Community Support

Hi,

What’s the reproducing steps of your error? Where did you change the data source? In the desktop or service?

 

Best Regards,

Community Support Team _Robert Qin

Tontaube2
Helper IV

Hi,

 

thank you!

 

It happened recurrently when changing the Name of the source-file in the desktop, and click on "apply changes and close".

 

Steps:

 

I copied a pbix and its Excel-source and renamed both of them form "Example7"xlsx/pbix to "Example8"xlsx/pbix - a crude attempt to versioning so that I do not loose progress I made.

 

I could open both of them individually in Excel and PowerBIDesktop. But of course the pbix still had the "old" source. I changed the name in the "Benutzerleiste" from 7 to 8, and tried to re-apply.

 

Both Excel as well as pbix  -  original as well as copied and renamed ones - are in a Dropbox-Folder.

v-robertq-msft
Community Support

Hi,

According to your description, it seems that you want to replace the original data source with a new one in the Power BI desktop, there are two ways:

  1. Go to Transform data-> data source setting, change the source of data:

vrobertqmsft_0-1632714604951.png

 

  1. Go to the power query editor, advanced editor, replace the file path to change the data source manually:

vrobertqmsft_1-1632714604957.png

 

Before updating your data source, you should first check if the column name and data type are the same as the columns in the original Excel file. If not, you will get an error.

Then you should update the reference of the next steps according to your actual situation.

 

 

Best Regards,

Community Support Team _Robert Qin