You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by sdiptapaul <sd...@gmail.com> on 2018/05/02 23:15:13 UTC

Apache Kylin with PowerBI Direct Query

I can connect PowerBI with ODBC but only import works but I want to use
DirectQuery or Live Connection as I have all big data sets. I have built
custom data connector for PowerBI using ODBC enabling Direct Query option
which connects and load the schema but when actual selecting fields for
reporting that fails to load the data. Question is is that something PowerBI
has to support that Direct Query on ODBC or anything can be made from Kylin?

Any alternative to connect to SQL server from Kylin after cube built so that
I can utilize Direct Query from PowerBI.

Appreciate your time looking into this and any help if you can provide.

Thanks
Sudipta

--
Sent from: http://apache-kylin.74782.x6.nabble.com/

Re: Apache Kylin with PowerBI Direct Query

Posted by Luke Han <lu...@gmail.com>.
The open source ODBC Driver does not support this capability,
you may contact vendors for such alternative solution.

Thanks.


Best Regards!
---------------------

Luke Han

On Wed, May 2, 2018 at 4:15 PM, sdiptapaul <sd...@gmail.com> wrote:

> I can connect PowerBI with ODBC but only import works but I want to use
> DirectQuery or Live Connection as I have all big data sets. I have built
> custom data connector for PowerBI using ODBC enabling Direct Query option
> which connects and load the schema but when actual selecting fields for
> reporting that fails to load the data. Question is is that something
> PowerBI
> has to support that Direct Query on ODBC or anything can be made from
> Kylin?
>
> Any alternative to connect to SQL server from Kylin after cube built so
> that
> I can utilize Direct Query from PowerBI.
>
> Appreciate your time looking into this and any help if you can provide.
>
> Thanks
> Sudipta
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>