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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

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?

Status: New
Comments
v-chuncz-msft
Community Support

@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
New Member

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

SDM_1997
Helper II

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
Regular Visitor

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