Big Query View -> PowerBI not reading column names correctly

[qtsweeney3435]

This is the view/output from bigquery with the following view.

SELECT
    * EXCEPT (_resource_row_id)
FROM (
  SELECT
    ROW_NUMBER() OVER(PARTITION BY id ORDER BY meta.lastUpdated DESC) as _resource_row_id,
    *
    FROM `cie-uwsem-hub.cie_uwsem_semi_uat.HealthcareService` AS p
) AS p
WHERE
  p._resource_row_id=1
  AND
  NOT EXISTS (
  SELECT
    *
  FROM
    UNNEST(p.meta.tag)
  WHERE
    code = 'DELETE')

When it loads into powerbi the unnest shows as:

I believe the problem is sourced from the schema, as powerbi can't read meta.secruity.system as it's own column.

Would anyone know how to reference the nested columns as an seperate alias for powerbi to read properly?

[Anonymous]

Did you find solution ?