Forum Discussion

jguillamet's avatar
jguillamet
Frequent Visitor
1 year ago
Solved

Cluster automaticos se rompen en Power Bi Services.

Hola, consulto, puede ser que al generar Cluster Automaticos a partir de un Grafico de Dispersión en Power BI Desktop, lo que se visualiza y funciona correctamente. Luego al subirlo a la Plataforma Power Bi, funciona por un tiempo, creo que hasta la nueva actualizacion del Dashboard y queda roto y no se puede visualizar ni en tablas, Segmentador, etc. 
Hay algo que lo puedo solucionar, para que cada vez muestre el Cluster formado inicialmente?
Gracias

  • Hello jguillamet,
    Thank you for reaching out to the Microsoft Fabric Forum Community. The issue with automatic clusters breaking in Power BI Service after a dashboard update occurs because clusters created in Power BI Desktop are static and don’t automatically update with data refreshes. New or changed data points may not align with the original cluster assignments, causing visuals like tables or slicers to break.

    Please consider the below points:

    • If your dataset uses DirectQuery or Live Connection, switch to Import mode in Power BI Desktop, as clustering requires creating a calculated column. Recreate the clusters and republish the report.
    • For dynamic updates, perform clustering in your data source (e.g: using Python’s or SQL) before loading into Power BI. Add a cluster column to your dataset, then use it in the scatter chart’s Legend field. This ensures clusters update with each refresh.
    • Ensure the scatter chart has a unique ID in the details field and an empty legend field before clustering. Verify refresh settings in Power BI Service and use the latest Power BI Desktop version.

    If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
    Thank you.

  • Hi jguillamet,

    May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

    Thank you.

     

2 Replies

  • v-ssriganesh's avatar
    v-ssriganesh
    Icon for Community Support rankCommunity Support

    Hi jguillamet,

    May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

    Thank you.

     

  • v-ssriganesh's avatar
    v-ssriganesh
    Icon for Community Support rankCommunity Support

    Hello jguillamet,
    Thank you for reaching out to the Microsoft Fabric Forum Community. The issue with automatic clusters breaking in Power BI Service after a dashboard update occurs because clusters created in Power BI Desktop are static and don’t automatically update with data refreshes. New or changed data points may not align with the original cluster assignments, causing visuals like tables or slicers to break.

    Please consider the below points:

    • If your dataset uses DirectQuery or Live Connection, switch to Import mode in Power BI Desktop, as clustering requires creating a calculated column. Recreate the clusters and republish the report.
    • For dynamic updates, perform clustering in your data source (e.g: using Python’s or SQL) before loading into Power BI. Add a cluster column to your dataset, then use it in the scatter chart’s Legend field. This ensures clusters update with each refresh.
    • Ensure the scatter chart has a unique ID in the details field and an empty legend field before clustering. Verify refresh settings in Power BI Service and use the latest Power BI Desktop version.

    If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
    Thank you.