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!
Have you taken a look at this post?
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.