How to Connect Apache Druid to Power Bi (Desktop/Service)

[Centurius_de]

Dear all, 

in our company we are using Apache Druid as a data storage. I would like to setup a data source and connect to our Druid Database.

Where do I start, what do I select as data source type do I take file or database? Since there is no dedicated option for apache druid.  I found some simple connection online as an example, but where do I define this in the first place? 

Cheers

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

[ams1 · Accepted solution]

Hi,

Start from a Blank query, go to Advanced Editor and paste your snippet there - but "pack some supplies" as there might be a long-ish way home if you haven't created a query before (and if your druid cluster is secured...) 😊

[Centurius_de]

maybe one additional question, is the incrmental update feature agnostic from the underlying system? i have managed to get it working with google big query, will it also work with Druid in general?

[ams1 · Accepted solution]

You mean "incremental refresh"? 

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#supported-data-...

P.S.: for further details on this "incremental refresh", please open another question - and please mark my previous reply as answer should you consider it answered your question 😊

[Centurius_de]

thank you, i have written druid queries before, i was just missing the starting point, will give it a try

[ams1]

Please mark my previous reply as answer should you consider it answered your question

[ams1 · Accepted solution]

Hi,

Start from a Blank query, go to Advanced Editor and paste your snippet there - but "pack some supplies" as there might be a long-ish way home if you haven't created a query before (and if your druid cluster is secured...) 😊