undefined

[Surender123]

Hello Sir, please help me . I want to import data in power bi from Apache druid . How can i create connections.

[Anonymous]

Hi @Surender123 ,

I think you can try to connect to Apache druid in Power BI by code as below.

let
  Query1 = Json.Document(Web.Contents("paste_url:paste_port/druid/v2/?pretty", 
[Headers=[#"Content-Type"="application/json"], 
Content=Text.ToBinary(
"{
""queryType"": ""groupBy"",
""dataSource"": ""paste_your_table"",
""dimensions"": [""dimension1""] ,
""granularity"": ""all"",
""aggregations"": 
       [
       {
       ""name"": ""metric1"",
       ""type"": ""longSum"",
       ""fieldName"": ""metric1""
       }
       ],       
""intervals"": [ ""2020-07-27T00:00:00.000/2020-08-03T00:00:00.000"" ]
}

  
  "
)
]
)),
    totable = Table.FromList(Query1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    expand = Table.ExpandRecordColumn(totable, "Column1", {"version", "timestamp", "event"}, {"Column1.version", "Column1.timestamp", "Column1.event"})
in
    expand

Best Regards,
Rico Zhou

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

[Surender123]

Hi

Thanks for support me, I used this query and got following error.

Error: DataSource.Error:Web.Contents with the Content opetion is only supported when connecting enonymously.

[Greg_Deckler]

@Surender123 Try using an ODBC driver: Connecting Tableau to Apache Druid - Stack Overflow