Google BigQuery nested JSON in Power BI

[Sophie_]

Hello,

do you have some best practice to use Google BigQuery nested JSON in Power BI ?

is it efficient ? 

For exemple how to load this nested table ?

Sophie

[Sophie_]

Hi  ,it is not a JSON, it's table GCP with STRUCT column :

create or replace table  `xxx.yyyy.test_nested` as (

SELECT *

from (  

  select 1 as id,  STRUCT('001' AS order_id, ['A1', 'B1'] AS item_name) order_item

  union all

  select 2 as id,    STRUCT('002' AS order_id, ['A1', 'C1'] AS item_name) order_item

)

)

so i want to load it PowerBi

Sophie

@Gaui

[gaurav-lakhotia]

Hi @Sophie_ , can you share the JSON response here?