Error in Loading Query: OLE DB or ODBC - Reached end of Buffer (JSON files)

[Anonymous]

Hello everyone!

I kept on getting this error in attempt to loading my query. Data source is a folder containing JSON files. I've already check data formats and replaced null values, as being recommended to most discussions I've read. But I still get this error message. Anyone knows how to make things work?

[Anonymous · Accepted solution]

Hi @Daryl-Lynch-Bzy,

I've already fixed the issue, turned out to be that the data source format has changed for the newer files.

Appreciate your help!

[Daryl-Lynch-Bzy]

Hi @Anonymous -  It looks like a memory issue, but we would need more information to help. 

Could you share the Power Query function that you created to read and transform the files? 

Are you reading the file/s from SharePoint Library?

How complex is the JSON?  How big?  How many JSON files?

You may need to consider separating Power Query from PBIX by using a Dataflow.  Dataflow can act as stepping stone in an Extract Transform and Load.  One dataflow to read or extract the file from SharePoint.  Then another Dataflow to do the transformations.  Then load to PBIX file.

Many thanks

Daryl