Status:
New
[BUG] Single BigQuery integer column generates an aggregated .json field with all columns
I have created this view in BigQuery: create view project.dataset.view1 as
SELECT
o.first
,o.id as theid
,p.id as otherid
FROM dataset.view2 as o
JOIN dataset.view3 as p on p.whatever = o.id ...
Hi,
According to the SELECT formula you used to create this view, it seems that the view do have three columns. I think you can follow this document to try to directly connect to the Power BI to select the tables and views:
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-bigquery
Best Regards,
Community Support Team _Robert Qin