cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sguenther Member
Member

Refresh error: "We reached the end of the buffer."

Hey guys,

 

Have a problem when updating me dataset in the service. It gives me the following message:

 

"We reached the end of the buffer."

 

Couldn't find anything that explains what I should do to solve it. Any ideas?

 

Thank you!

9 REPLIES 9
BhaveshPatel Super Contributor
Super Contributor

Re: Refresh error: "We reached the end of the buffer."

@sguenther

 

Please see the screenshot. Possible Reason.service status.PNG

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
v-ljerr-msft Super Contributor
Super Contributor

Re: Refresh error: "We reached the end of the buffer."

Hi @sguenther,

 

What data source are you using in your scenario? Is there any measures have the same name as a table in your dataset?

 

Regards

sguenther Member
Member

Re: Refresh error: "We reached the end of the buffer."

Hi @v-ljerr-msft,

 

I'm using the following data sources: Google Analytics, PostgreSQL, Odata (from Dynamics CRM) and Web.

No measure has the same name as a table.

 

Regards

v-ljerr-msft Super Contributor
Super Contributor

Re: Refresh error: "We reached the end of the buffer."

Hi @sguenther,

 

I found there is a new issue on Power BI Support currently which may relate to your issue: "Some Power BI customers in North Europe are experiencing data refresh failures with gateway connecting to on prem data sources. Engineers are working on a resolution for this. Next update 11/14/2016 @ 18:30 PST."

 support.PNG

Could you wait for that issue being fixed, then check if your issue remains?Smiley Happy

 

Regards

dawidvh Regular Visitor
Regular Visitor

Re: Refresh error: "We reached the end of the buffer."

Having the same issue, and seems to be caused by referenced queries. If I reduce the queries referencing the source queries, the problem goes away.

 

There doesn't seem to be lots of info on this topic, has anyone been able to get some solid answers on this yet?

pjbogacz Visitor
Visitor

Re: Refresh error: "We reached the end of the buffer."

Hi! It seems that I've been having this issue as well - but it's quite random. Every couple of days scheduled data refresh fails with this error, mentioning different table everytime. Other than that automated and on demand refresh works fine, even though I didn't change anything nor tried to fix the issue. However, the error occurs often enough for the issue to become problematic - the scheduled refresh failed two times this week.

 

I'd also love to know if anyone has been able to find anything regarding this error?

cgeraeds Regular Visitor
Regular Visitor

Re: Refresh error: "We reached the end of the buffer."

Having the same problem.

When I update the JSON source file by updating the data source settings [NAME FILE_DATE OF FILE] and then click refresh it says:

We reached the end of the buffer. 

This happens in the table where the source is first referenced.

 

Any solutions?

 

Thank you

dawidvh Regular Visitor
Regular Visitor

Re: Refresh error: "We reached the end of the buffer."

Hi @cgeraeds 

 

What API are you getting the JSON from?


cgeraeds Regular Visitor
Regular Visitor

Re: Refresh error: "We reached the end of the buffer."

Hello @dawidvh ,

 

From our system developer I understand it's done with the Rails Framework via the to_json() command, more can be found here:
https://apidock.com/rails/ActiveRecord/Serialization/to_json

 

Is that enough information for you?

 

Kind Regards,
Chris

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 48 members 866 guests
Please welcome our newest community members: