Forum Discussion

nemechek's avatar
nemechek
Frequent Visitor
4 years ago

Google Cloud Platform and Json File

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

Need Help

5 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    4 years ago

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

     

    Pat

     

    • nemechek's avatar
      nemechek
      Frequent Visitor
      4 years ago

      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

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    4 years ago

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

    Pat

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      nemechek
      Frequent Visitor
      4 years ago

      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