topic Google BigQuery nested JSON in Power BI in Developer

Google BigQuery nested JSON in Power BI

Sophie_ — Mon, 14 Oct 2024 09:48:12 GMT

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

gaurav-lakhotia — Mon, 14 Oct 2024 10:14:50 GMT

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

Sophie_ — Mon, 14 Oct 2024 12:32:04 GMT

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