Refresh failing - Unable to read beyond the end of the stream

[danilodovetail]

Hi,

I have set up my dataset to auto-refresh every day in the morning, but lately, the refresh has failed with the message below:

We're sorry, an error occurred during evaluation.;Unable to read beyond the end of the stream. Unable to read beyond the end of the stream. Unable to read beyond the end of the stream.. The exception was raised by the IDbCommand interface. Table: XXXXX.

It does work when I refresh it locally with PBI desktop.

How can I figure out what might be going wrong? 

Is there a way to run performance analysis on the refresh process to figure out which steps are costing the most?

[v-chuncz-msft]

@danilodovetail 

I cannot reproduce the issue. You may take a look at Optimization guide for Power BI and try the latest version to republish and refresh the report. 

[danilodovetail]

I will take a look at this guide and see if I can improve it. I will let you know. Thanks

[SDM_1997]

For anyone who is facing this error in service and not in Desktop.
If your dataset is connected to a dataflow, then change the Enhanced Compute Engine option of the dataflow to either 'Off' or to 'Optimized'.
Keeping the Enhanced Compute Engine 'On' means Query folding is enabled, so the dataset can also use the query folding using the new dataflow connector.
For my case, tables which had no merging and references anywhere had zero issues with the Query Folding turned on. But for tables with mergings and references, I was facing this error multiple times.
As soon as I turned the Enhanced Compute Engine Off, the issues were gone and all refreshes were happening normally in service again.

[ramdasanudas]

get more space in C: drive
or
Try to clean the data load cache: File -> Options and Settings -> Options -> Data Load -> Clear cache and Save the file and Load again