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...
Need Help
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