JSON nested list/records parsing in PBI

Hi PBI Guru’s,

In the JSON files, rows have a nested list and lower-level individual records as seen below.

"rows": [

    {

      "dimensionValues": [

        {

          "value": "20230707"

        },

        {

          "value": "Medium"

        },

        {

          "value": "desktop"

        },

        {

          "value": "Male"

        },

        {

          "value": "source"

        }

      ],

      "metricValues": [

        {

          "value": "15"

        },

        {

          "value": "110"

        }

      ]

Here is how it looks in PBI query after rows are filtered & expand –

DimensionValues - Individual records

MetricValues - Individual records

Is there a way to get row values of the 5 dimensions and 2 metrics in the same step or fewer steps so that the result will look like this..

I have tried functions Table.FromRows(List.Split…) but performance is terrible especially when we have multiple large JSON data files. Any help or recommendations will be much appreciated.

Thanks in advance,

Ann Tom