I will really appreciate your advice and best practice working with Xero JSON data because I saw some of the contributors topics to explain how to work with JSON but I cannot standardise my approach and our company receives quite a lot of data through JSON files. Each software has its own unique nested way to deliver JSON data which is quite difficult to work with in Power BI or maybe this could be solved in our datawarehouse, we use GoogleBigQuery?
My files are nested many times and I was wondering what is the best way to deal with the new data that will create more rows?
This is how I have dealt with NESTED JSONS but my file is becoming very slow and sometimes I am experiencing error message "We reached the end of buffer" which I doubt is the most efficient way to deal with JSON files, I have 12 more tables like this one using the same way to deal with the JSON files. I have attached my code below: