topic Re: Clustering-automatically find clusters option - Direct Query in Developer https://community.fabric.microsoft.com/t5/Developer/Clustering-automatically-find-clusters-option-Direct-Query/m-p/2186825#M32882 <P>Hi&nbsp;@Anonymous</a>&nbsp;</P> <P class="">Based on my test, Power BI doesn't support you to use c<SPAN>lustering-automatically find clusters option on tables which use Power BI Dataset as datasource.</SPAN></P> <P class=""><SPAN>Clustering-automatically find clusters option will&nbsp;create a group (a new calculate column).</SPAN></P> <P class=""><SPAN>Currently we have two connection mode to connect to Power BI Dataset, Live connection / Direct Query.</SPAN></P> <P class=""><SPAN>If you select to connect live, then there is no query defined, and the entire external model is shown in the field list. There is no sense in which a new model is being created; in other words, it's not possible to define new calculated columns, hierarchies, relationships, and so on.</SPAN></P> <P class=""><SPAN>When we convert to Direct Query, we still couldn't use this function on visual based on tables from Power BI Dataset.</SPAN></P> <P class=""><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.png" style="width: 663px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/630281iE91BF0FE16CF5C98/image-size/large?v=v2&amp;px=999" role="button" title="1.png" alt="1.png" /></span></SPAN></P> <P class=""><SPAN>And I try to add an other table from other data source like Execl, this function appears in the visual based on this table.</SPAN></P> <P class=""><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="3.png" style="width: 322px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/630283i93F732EC3732030D/image-size/large?v=v2&amp;px=999" role="button" title="3.png" alt="3.png" /></span></SPAN></P> <P class=""><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2.png" style="width: 504px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/630282i7AEFF3A245896B23/image-size/large?v=v2&amp;px=999" role="button" title="2.png" alt="2.png" /></span></SPAN></P> <P>Best Regards,<BR />Rico Zhou</P> <P>&nbsp;</P> <P>If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</P> Fri, 12 Nov 2021 07:51:31 GMT Anonymous 2021-11-12T07:51:31Z Clustering-automatically find clusters option - Direct Query https://community.fabric.microsoft.com/t5/Developer/Clustering-automatically-find-clusters-option-Direct-Query/m-p/2180833#M32821 <P><SPAN>How to use Clustering-automatically find clusters option with report based on&nbsp;<STRONG><FONT>Live connection to power bi dataset?</FONT></STRONG></SPAN></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="guitrferrari_0-1636472345652.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/628183i3A657EFB56572A00/image-size/medium?v=v2&amp;px=400" role="button" title="guitrferrari_0-1636472345652.png" alt="guitrferrari_0-1636472345652.png" /></span></P><P>&nbsp;</P> Tue, 09 Nov 2021 15:40:03 GMT https://community.fabric.microsoft.com/t5/Developer/Clustering-automatically-find-clusters-option-Direct-Query/m-p/2180833#M32821 Anonymous 2021-11-09T15:40:03Z Re: Clustering-automatically find clusters option - Direct Query https://community.fabric.microsoft.com/t5/Developer/Clustering-automatically-find-clusters-option-Direct-Query/m-p/2186825#M32882 <P>Hi&nbsp;@Anonymous</a>&nbsp;</P> <P class="">Based on my test, Power BI doesn't support you to use c<SPAN>lustering-automatically find clusters option on tables which use Power BI Dataset as datasource.</SPAN></P> <P class=""><SPAN>Clustering-automatically find clusters option will&nbsp;create a group (a new calculate column).</SPAN></P> <P class=""><SPAN>Currently we have two connection mode to connect to Power BI Dataset, Live connection / Direct Query.</SPAN></P> <P class=""><SPAN>If you select to connect live, then there is no query defined, and the entire external model is shown in the field list. There is no sense in which a new model is being created; in other words, it's not possible to define new calculated columns, hierarchies, relationships, and so on.</SPAN></P> <P class=""><SPAN>When we convert to Direct Query, we still couldn't use this function on visual based on tables from Power BI Dataset.</SPAN></P> <P class=""><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.png" style="width: 663px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/630281iE91BF0FE16CF5C98/image-size/large?v=v2&amp;px=999" role="button" title="1.png" alt="1.png" /></span></SPAN></P> <P class=""><SPAN>And I try to add an other table from other data source like Execl, this function appears in the visual based on this table.</SPAN></P> <P class=""><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="3.png" style="width: 322px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/630283i93F732EC3732030D/image-size/large?v=v2&amp;px=999" role="button" title="3.png" alt="3.png" /></span></SPAN></P> <P class=""><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2.png" style="width: 504px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/630282i7AEFF3A245896B23/image-size/large?v=v2&amp;px=999" role="button" title="2.png" alt="2.png" /></span></SPAN></P> <P>Best Regards,<BR />Rico Zhou</P> <P>&nbsp;</P> <P>If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.</P> Fri, 12 Nov 2021 07:51:31 GMT https://community.fabric.microsoft.com/t5/Developer/Clustering-automatically-find-clusters-option-Direct-Query/m-p/2186825#M32882 Anonymous 2021-11-12T07:51:31Z