Google Cloud Platform and Json File

[nemechek]

Hello PBI Community, 

I have an issue and i did not find the answer on the web,

I have a data base in GCP (Google Cloud Platform) this database is a multidimentional file format (.JSON). So i use the connection "Google Big Query" to import the data which it works. But it imports the data directly in table format and does not recognize the JSON Format. So impossible for me to use the data. Do you have any idea to how can i import JSON File that are stored in GCP ?  

Thanks for your help,

Nemechek

P.S I know how to import a JSON file locally, but here the JSON File is stored in GCP

[Anonymous]

Hi @nemechek ,

Please refer to the official document:

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nemechek]

Hi Eyelin9,

Thanks for the tips, but unfortunately it doesn't work because it extracts all data in lines. Let's take your example file, when you expand the columns (e.g first one); I can only expands in new lines, instead of expanding in new columns. and expand the lists in new lines. Did you manage to expand data in colums in your example ?

Thanks, 

nemechek

[mahoneypat]

I meant you could add a custom column in the query showed in the pic with = Json.Document([source])  for example.

Pat

[mahoneypat]

You can pass that text into the Json.Document function, and then drill into it from there.

Pat

[nemechek]

Hi thank you for your response,

Power bi directly import data from GCP directly in a table format, the function Json.Document cannot accept table format in entry:

let
Source = GoogleBigQuery.Database(null),
#"XX" = Source{[Name="XX"]}[Data],
YY_Schema = #"XX"{[Name="YY",Kind="Schema"]}[Data],
sales_history_View = YY_Schema{[Name="sales_history",Kind="View"]}[Data]
in
sales_history_View