Forum Discussion
Turn off table inference
I have a json document that is an array of arrays. I dont want to flatten this. The problem is that sometimes there is 1 array within the array, sometimes there is more. If there is 1, power query fl...
Hi, Kurren ;
If you're trying to load a JSON Lines file, the following sample M code converts all JSON Lines input to a single flattened table automatically:
You'll then need to use an Expand operation to combine the lines together.
Power BI JSON Connection: 3 Easy Methods - Learn | Hevo (hevodata.com)
Power Query JSON connector - Power Query | Microsoft Docs
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.