question power bi spark directquery support in Archives of Support Questions (Read Only) https://community.cloudera.com/t5/Archives-of-Support-Questions/power-bi-spark-directquery-support/m-p/221268#M84445 <P>Since recently PoweBI is support spark "Direct Query" connection. </P><P>Could anyone connect to spark in kerberized HDP cluster?</P><P>In my case i have tried many different ways, but without success.</P><P>My connection string is Server - spark thrift service fqdn and port, Protocol - Standard, Mode - DirectQuery</P><P>In next dialog box contain my ActiveDirectory login and password.</P><P>But connection is not success: </P><P>Details: "ODBC: ERROR [28000] [Microsoft][ThriftExtension] (2) Error occured during authentication."</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="91732-capture4.png" style="width: 899px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15789i9D6EC86CA39FA9AE/image-size/medium?v=v2&amp;px=400" role="button" title="91732-capture4.png" alt="91732-capture4.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="91733-capture5.png" style="width: 895px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15790iC41818FB3806149E/image-size/medium?v=v2&amp;px=400" role="button" title="91733-capture5.png" alt="91733-capture5.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="91734-capture6.png" style="width: 645px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15791iF98C5D0309A3A6E9/image-size/medium?v=v2&amp;px=400" role="button" title="91734-capture6.png" alt="91734-capture6.png" /></span></P> Sun, 18 Aug 2019 02:17:23 GMT ururu 2019-08-18T02:17:23Z power bi spark directquery support https://community.cloudera.com/t5/Archives-of-Support-Questions/power-bi-spark-directquery-support/m-p/221268#M84445 <P>Since recently PoweBI is support spark "Direct Query" connection. </P><P>Could anyone connect to spark in kerberized HDP cluster?</P><P>In my case i have tried many different ways, but without success.</P><P>My connection string is Server - spark thrift service fqdn and port, Protocol - Standard, Mode - DirectQuery</P><P>In next dialog box contain my ActiveDirectory login and password.</P><P>But connection is not success: </P><P>Details: "ODBC: ERROR [28000] [Microsoft][ThriftExtension] (2) Error occured during authentication."</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="91732-capture4.png" style="width: 899px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15789i9D6EC86CA39FA9AE/image-size/medium?v=v2&amp;px=400" role="button" title="91732-capture4.png" alt="91732-capture4.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="91733-capture5.png" style="width: 895px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15790iC41818FB3806149E/image-size/medium?v=v2&amp;px=400" role="button" title="91733-capture5.png" alt="91733-capture5.png" /></span></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="91734-capture6.png" style="width: 645px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15791iF98C5D0309A3A6E9/image-size/medium?v=v2&amp;px=400" role="button" title="91734-capture6.png" alt="91734-capture6.png" /></span></P> Sun, 18 Aug 2019 02:17:23 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/power-bi-spark-directquery-support/m-p/221268#M84445 ururu 2019-08-18T02:17:23Z Re: power bi spark directquery support https://community.cloudera.com/t5/Archives-of-Support-Questions/power-bi-spark-directquery-support/m-p/221269#M84446 <P>For kerberos connection needs to click on tab "windows" and type kerberos parameters</P><P>What funny i thought this is just string, because default tab was "Username/Password"</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="91751-capture7.png" style="width: 713px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15788i5B059A4287998086/image-size/medium?v=v2&amp;px=400" role="button" title="91751-capture7.png" alt="91751-capture7.png" /></span></P><P>After this right windows realm, connection was success.</P> Sun, 18 Aug 2019 02:17:04 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/power-bi-spark-directquery-support/m-p/221269#M84446 ururu 2019-08-18T02:17:04Z