Microsoft.Mashup.Evaluator.MessageBasedOutputStream+BinaryChunkyMessage - System.InvalidOperationExc

[Anonymous]

I got the error above when trying to refresh data.

I used excel as a source.

PowerBI Desktop.

Any suggestions?

[v-cazheng-msft]

Hi @Anonymous 

Are you using the latest version of Power BI Desktop? Do you find any error in Power Query Editor for related query? Is the data amount very large? Compared to the original table, is there any change the table structure in data source? If you create a new report based on the same Excel workbook, will you get same error when refreshing it?

Best Regards,

Community Support Team _ Caiyun

[Anonymous]

Hello,

All I did was leave some entries blank in the initial excel spreadsheet to allow for my client to fill it in with actual data, instead of the dummy I put there as demo. Eversince, it stopped working and despite loading in the transform data the new (mixed blank and filled data) input, it wont load on the report. 

Any ideas?

Thanks !

[v-cazheng-msft]

Hi @Anonymous 

Thanks for your reply! May I know whether these blank entries are the rows in the table but not the column names of it? Are these blanks in an entire row or in different rows? If the values of entire row are blanks, I do recommend you remove these entire blanks from the data source. If there are any new input added to the data source by the customers, these data will be loaded to the report after refreshing.

Best Regards,

Community Support Team _ Caiyun