Forum Discussion
qtsweeney3435
3 years agoFrequent Visitor
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
- AnonymousNot applicable
Did you find solution ?