Apache Pinot #pinot-power-bi

Join Slack

Kishore G

11/06/2019, 4:52 PM

we are looking into it. will have some update by end of this week.

Kishore G

11/06/2019, 4:53 PM

how soon do you need this

Madan Gangadaharaiah

11/06/2019, 5:14 PM

by this week is fine with me Kishore

Madan Gangadaharaiah

11/08/2019, 4:41 PM

Hi Kishore

Kishore G

11/08/2019, 4:59 PM

Hi Madan

Madan Gangadaharaiah

11/08/2019, 5:02 PM

Gm!

Kishore G

11/08/2019, 5:02 PM

Morning

Madan Gangadaharaiah

11/08/2019, 5:15 PM

Any update on connecting to power bi

Madan Gangadaharaiah

11/08/2019, 5:15 PM

Kishore G

11/08/2019, 6:08 PM

I think it can be done. We need to try it out.

Kishore G

11/08/2019, 6:09 PM

Will update you once we get a chance to try it

Madan Gangadaharaiah

11/08/2019, 6:22 PM

Sure thanks

Madan Gangadaharaiah

11/11/2019, 4:59 PM

Hi Kishore

Madan Gangadaharaiah

11/11/2019, 4:59 PM

Gm!

Madan Gangadaharaiah

11/11/2019, 4:59 PM

did you get a chance to look into the power bi thing

Kishore G

11/11/2019, 5:01 PM

yes. @User got the presto-pinot working. we will publish the docker image. You should be able to connect to presto following the instructions here

https://www.youtube.com/watch?v=1eQEMTnngXk▾

Madan Gangadaharaiah

11/11/2019, 5:36 PM

Hi Kishore....

Madan Gangadaharaiah

11/11/2019, 5:37 PM

i heard from Xiang that you connected Pinot to PowerBI using REST API

Kishore G

11/11/2019, 6:00 PM

there are two different modes to connect - https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery

Kishore G

11/11/2019, 6:01 PM

RestAPI will use the import mode which means users will download all the data from Pinot to their desktop, this is not recommended for large scale data

Madan Gangadaharaiah

11/11/2019, 6:15 PM

My dataset is small and i need to test with REST API

Madan Gangadaharaiah

11/11/2019, 6:17 PM

Error

Madan Gangadaharaiah

11/11/2019, 6:17 PM

I am facing this issue

Madan Gangadaharaiah

11/11/2019, 9:14 PM

Pls suggest on this

Kishore G

11/11/2019, 9:35 PM

we are not familiar with that interface.

Kishore G

11/11/2019, 9:37 PM

lets setup a time to chat

Kishore G

06/18/2020, 8:58 PM

@User has left the channel

Mohan Krishnan

06/23/2022, 12:32 AM

Hey folks just curious, what is the best way to get PowerBI speaking to Pinot using DirectQuery? Any links you can point me to get more information?

DV Kumar

07/06/2022, 7:50 AM

hello all, with the increasing number of data/business analyst using PowerBI, does Apache Pinot have any connections/plugins ?

Xiang Fu

07/07/2022, 5:03 AM

Hi, native Pinot odbc is on the roadmap. Current solution is to have presto as the bridge. So powerBi connects to presto using odbc then presto can work with Pinot