You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by "cong.xiang@hand-china.com" <co...@hand-china.com> on 2017/06/12 16:18:48 UTC

kylin connnect power bi by odbc

kylin version 1.6 
power bi  v2.46
odbc driver v1.6
when kylin connect power bi ,occuring below error,but when kylin connect tableau ,this is success!





cong.xiang@hand-china.com

Re: Re: kylin connnect power bi by odbc

Posted by Alberto Ramón <a....@gmail.com>.
Hello, Some clarifications

First, The connection ODBC1.6 can be configured check Kylin and PowerBi.odt
<https://github.com/albertoRamon/Kylin/tree/master/KylinWithPowerBi>

Second, There is a bug in Kylin 1.6 Kylin 2235
<https://issues.apache.org/jira/browse/KYLIN-2235>

Third, Older versions of Kylin 1 year ago, worked fine, but actuals no



On 13 June 2017 at 15:37, Billy Liu <bi...@apache.org> wrote:

> I don't know. It's not Kylin's setting page. Your snapshot could not be
> shown. Based on my limited experience on PowerBI, http is supported.
>
> 2017-06-13 19:15 GMT+08:00 cong.xiang@hand-china.com <
> cong.xiang@hand-china.com>:
>
> > this is a bug?when use tableau connect kylin,can select http in
> dialog,but
> > when use power bi,no http
> >
> > ------------------------------
> > cong.xiang@hand-china.com
> >
> >
> > *From:* Billy Liu <bi...@apache.org>
> > *Date:* 2017-06-13 18:29
> > *To:* cong.xiang@hand-china.com
> > *CC:* dev <de...@kylin.apache.org>
> > *Subject:* Re: Re: kylin connnect power bi by odbc
> > how about HTTP protocol, instead of HTTPS.
> >
> > 2017-06-13 15:54 GMT+08:00 cong.xiang@hand-china.com <
> > cong.xiang@hand-china.com>:
> >
> > > driver={KylinODBCDriver};SERVER=xxxxxxx;PORT=7070;
> > > this is my driver
> > > then,occuur a dialog
> > > protocol:https
> > > server host:xxxx
> > > port:7070
> > > username:ADMIN
> > > password:KYLIN
> > > I click "connect" button,occuring "username/password not authorized,or
> > > server out of service"
> > > this is version error?
> > >
> > > ------------------------------
> > > cong.xiang@hand-china.com
> > >
> > >
> > > *From:* Billy Liu <bi...@apache.org>
> > > *Date:* 2017-06-13 15:16
> > > *To:* dev <de...@kylin.apache.org>
> > > *Subject:* Re: kylin connnect power bi by odbc
> > > No picture attached. Could you describe your error in text?
> > >
> > > 2017-06-13 0:18 GMT+08:00 cong.xiang@hand-china.com <
> > > cong.xiang@hand-china.com>:
> > >
> > > > kylin version 1.6
> > > > power bi  v2.46
> > > > odbc driver v1.6
> > > > when kylin connect power bi ,occuring below error,but when kylin
> > connect
> > > > tableau ,this is success!
> > > >
> > > >
> > > >
> > > > ------------------------------
> > > > cong.xiang@hand-china.com
> > > >
> > >
> > >
> >
> >
>

Re: Re: kylin connnect power bi by odbc

Posted by Billy Liu <bi...@apache.org>.
I don't know. It's not Kylin's setting page. Your snapshot could not be
shown. Based on my limited experience on PowerBI, http is supported.

2017-06-13 19:15 GMT+08:00 cong.xiang@hand-china.com <
cong.xiang@hand-china.com>:

> this is a bug?when use tableau connect kylin,can select http in dialog,but
> when use power bi,no http
>
> ------------------------------
> cong.xiang@hand-china.com
>
>
> *From:* Billy Liu <bi...@apache.org>
> *Date:* 2017-06-13 18:29
> *To:* cong.xiang@hand-china.com
> *CC:* dev <de...@kylin.apache.org>
> *Subject:* Re: Re: kylin connnect power bi by odbc
> how about HTTP protocol, instead of HTTPS.
>
> 2017-06-13 15:54 GMT+08:00 cong.xiang@hand-china.com <
> cong.xiang@hand-china.com>:
>
> > driver={KylinODBCDriver};SERVER=xxxxxxx;PORT=7070;
> > this is my driver
> > then,occuur a dialog
> > protocol:https
> > server host:xxxx
> > port:7070
> > username:ADMIN
> > password:KYLIN
> > I click "connect" button,occuring "username/password not authorized,or
> > server out of service"
> > this is version error?
> >
> > ------------------------------
> > cong.xiang@hand-china.com
> >
> >
> > *From:* Billy Liu <bi...@apache.org>
> > *Date:* 2017-06-13 15:16
> > *To:* dev <de...@kylin.apache.org>
> > *Subject:* Re: kylin connnect power bi by odbc
> > No picture attached. Could you describe your error in text?
> >
> > 2017-06-13 0:18 GMT+08:00 cong.xiang@hand-china.com <
> > cong.xiang@hand-china.com>:
> >
> > > kylin version 1.6
> > > power bi  v2.46
> > > odbc driver v1.6
> > > when kylin connect power bi ,occuring below error,but when kylin
> connect
> > > tableau ,this is success!
> > >
> > >
> > >
> > > ------------------------------
> > > cong.xiang@hand-china.com
> > >
> >
> >
>
>

Re: Re: kylin connnect power bi by odbc

Posted by "cong.xiang@hand-china.com" <co...@hand-china.com>.
how about HTTP protocol, instead of HTTPS.

2017-06-13 15:54 GMT+08:00 cong.xiang@hand-china.com <
cong.xiang@hand-china.com>:

> driver={KylinODBCDriver};SERVER=xxxxxxx;PORT=7070;
> this is my driver
> then,occuur a dialog
> protocol:https
> server host:xxxx
> port:7070
> username:ADMIN
> password:KYLIN
> I click "connect" button,occuring "username/password not authorized,or
> server out of service"
> this is version error?
>
> ------------------------------
> cong.xiang@hand-china.com
>
>
> *From:* Billy Liu <bi...@apache.org>
> *Date:* 2017-06-13 15:16
> *To:* dev <de...@kylin.apache.org>
> *Subject:* Re: kylin connnect power bi by odbc
> No picture attached. Could you describe your error in text?
>
> 2017-06-13 0:18 GMT+08:00 cong.xiang@hand-china.com <
> cong.xiang@hand-china.com>:
>
> > kylin version 1.6
> > power bi  v2.46
> > odbc driver v1.6
> > when kylin connect power bi ,occuring below error,but when kylin connect
> > tableau ,this is success!
> >
> >
> >
> > ------------------------------
> > cong.xiang@hand-china.com
> >
>
>

Re: Re: kylin connnect power bi by odbc

Posted by Billy Liu <bi...@apache.org>.
how about HTTP protocol, instead of HTTPS.

2017-06-13 15:54 GMT+08:00 cong.xiang@hand-china.com <
cong.xiang@hand-china.com>:

> driver={KylinODBCDriver};SERVER=xxxxxxx;PORT=7070;
> this is my driver
> then,occuur a dialog
> protocol:https
> server host:xxxx
> port:7070
> username:ADMIN
> password:KYLIN
> I click "connect" button,occuring "username/password not authorized,or
> server out of service"
> this is version error?
>
> ------------------------------
> cong.xiang@hand-china.com
>
>
> *From:* Billy Liu <bi...@apache.org>
> *Date:* 2017-06-13 15:16
> *To:* dev <de...@kylin.apache.org>
> *Subject:* Re: kylin connnect power bi by odbc
> No picture attached. Could you describe your error in text?
>
> 2017-06-13 0:18 GMT+08:00 cong.xiang@hand-china.com <
> cong.xiang@hand-china.com>:
>
> > kylin version 1.6
> > power bi  v2.46
> > odbc driver v1.6
> > when kylin connect power bi ,occuring below error,but when kylin connect
> > tableau ,this is success!
> >
> >
> >
> > ------------------------------
> > cong.xiang@hand-china.com
> >
>
>

Re: Re: kylin connnect power bi by odbc

Posted by "cong.xiang@hand-china.com" <co...@hand-china.com>.
No picture attached. Could you describe your error in text?

2017-06-13 0:18 GMT+08:00 cong.xiang@hand-china.com <
cong.xiang@hand-china.com>:

> kylin version 1.6
> power bi  v2.46
> odbc driver v1.6
> when kylin connect power bi ,occuring below error,but when kylin connect
> tableau ,this is success!
>
>
>
> ------------------------------
> cong.xiang@hand-china.com
>

Re: kylin connnect power bi by odbc

Posted by Billy Liu <bi...@apache.org>.
No picture attached. Could you describe your error in text?

2017-06-13 0:18 GMT+08:00 cong.xiang@hand-china.com <
cong.xiang@hand-china.com>:

> kylin version 1.6
> power bi  v2.46
> odbc driver v1.6
> when kylin connect power bi ,occuring below error,but when kylin connect
> tableau ,this is success!
>
>
>
> ------------------------------
> cong.xiang@hand-china.com
>