"OLE DB- oder ODBC-Fehler : [DataFormat.Error] Das Ende des Puffers wurde erreicht.. ".

[Anonymous]

Hi, 

I am writing a query that is working for getting 1000 lines of data. When I try to get more pages of data, I don't get any error message in the Query Editor. I even see the Preview of the tables.

However, when I try to "close and update" the query, it is loading very long and gives me the following message:

Fehler beim Speichern von Änderungen auf dem Server. Zurückgegebener Fehler: "OLE DB- oder ODBC-Fehler : [DataFormat.Error] Das Ende des Puffers wurde erreicht.. ".

I have a very similar query that is getting Dataset of more than 1000 lines from the same Source of data.

Do you know what can be the issue? Thank you!

[Watsky]

Have you taken a look at this post? 

https://community.powerbi.com/t5/Desktop/Error-oledb-or-odbc-error-data-format-We-reached-the-end-of...