Forum Discussion

qtsweeney3435's avatar
qtsweeney3435
Frequent Visitor
3 years ago

Big Query View -> PowerBI not reading column names correctly

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?

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Did you find solution ?