Refresh fails with error We reached the end of the buffer.

[vpattel]

I use Power BI Premium Capacity Metrics app to fetch metrics about the embedded capacities running in my tenant. The dataset refresh was running fine until yesterday. Suddently reports refresh failure:

Data source error: We reached the end of the buffer.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.
Cluster URI: WABI-US-WEST2-redirect.analysis.windows.net
Activity ID: 158462dc-0626-4931-a609-acb4d47be4b2
Request ID: 9ac09b8e-0f00-c58a-db8b-8a958d3e6972
Time: 2022-03-10 05:35:42Z

Tried manual refresh as well. Fails with same error.

Appreciate any pointers on what could possibly be the issue.

[asccampos]

I could solve the issue by clearing the data cache on Power Bi Desktop / File / Options & Settings / Options / Data load / Data Cache Management Options and increasing it as well.

[v-kkf-msft · Accepted solution]

Hi @vpattel ,

Please check if it is caused by the following reasons ：

1.Mismatch between the data types of the keys used in relationships.
2.Improper date formats of the date fields in relationships.
3.(null) values in columns with decimal/whole number data types

Make sure the data types of both the fields in a relationship are same. replace (null) values with 0 for decimal or whole number data types.

I found these threads below that have similar problems to yours, please check the solutions inside. Hope they can help you solve the problem too.

https://community.powerbi.com/t5/Power-Query/We-reached-end-of-buffer-Error/td-p/989369 

https://community.powerbi.com/t5/Power-Query/Help-with-We-Reach-the-end-of-the-buffer-message/td-p/6... 

https://rohitvangala.wordpress.com/2017/02/02/error-the-exception-was-raised-by-idatareader-interfac... 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vpattel]

Thank you @v-kkf-msft for the pointers. The issue apparently seems to be null values. I recently added a new embedded capacity to the metrics app which did not have any workspace/dataset & other artifacts.

Refresh failures started exactly after adding the new capacity. Now that workspace & reports are created on the new capacity, refresh is running fine now.