Help with error message - scheduled refresh

[NovaBI]

Hi all,

a user set up a report that is fed by Json-files from a on-prem server.

I advised to create a service user that can be used in the gateway source. Everything works fine.

But form time to time we receive an error (not every day, just unsystematically), any guide on that? 

Thanks in advance!

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"We reached the end of the buffer."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataFormat.Error"}}],"exceptionCulprit":1}}} Table: md_s manual entry.

[v-yetao1-msft]

Hi @NovaBI 

This can have several problems behind, check the documentation below with information about possible errors and examples:

Solved: DataFormat.Error: We reached the end of the buffer... - Microsoft Power BI Community

Solved: DataFormat.Error: We reached the end of the buffer... - Microsoft Power BI Community

Solved: JSON File: reached end of buffer - Microsoft Power BI Community

Solved: Error: oledb or odbc error data.format We reached ... - Microsoft Power BI Community

Solved: Pivot Column results in DataFormat.Error: We reac... - Microsoft Power BI Community

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.