Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
When i add the data in that view to PowerBi, the column p.id it shows as Json string with all the three columns, while it should be only an integer.
This is an example of what i see:
{""v"":{""f"":[{""v"":""name""},{""v"":""11""},{""v"":""9""}]}}
In BigQuery and also in Google Data Studio and KlipFolio, it just looks fine with the integer value I'm expecting.
Can somebody shed some light on this? It's driving me nuts. Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.