Power Query is very slow now

[gregoliveira]

Hi,

I am trying to create a dataflow. However, Power Query Online is not working properly. The following query is processing forever...

let

  Origem = Table.FromList(

    {"Rascunho",

    "Proposta",

    "Proposta - Tempo Real",

    "Em Análise",

    "Em Análise - Tempo Real",

    "Revisão",

    "Recusada",

    "Anulada",

    "Aprovada",

    "Em Execução",

    "Fechada",

    "Finalizada"

    },

    null,

    {"statusSGO"}

  ),

  // Coluna funciona com um index para statusSGO

  #"Adicionando status" = Table.AddIndexColumn(Origem, "state", 1, 1, Int64.Type),

  #"Organizando colunas" = Table.ReorderColumns(#"Adicionando status", {"state", "statusSGO"}),

  #"Indicando tipos colunas" = Table.TransformColumnTypes(#"Organizando colunas", {{"statusSGO", type text}})

in

  #"Indicando tipos colunas"

[v-yetao1-msft]

Hi @gregoliveira 

I found some similar cases, maybe you can refer to them.

Solved: Slow Power Query - Microsoft Power BI Community

Solved: Power Query load from Dataflow is excruciatingly s... - Microsoft Power BI Community

Best Regards,
Community Support Team _ Ailsa Tao

[gregoliveira]

Hi.

After I closed and re-enter, it started to work normaly.

Thanks.

[v-yetao1-msft]

Hi @gregoliveira 

I am so glad to hear that your issue has been fixed . I will change the status to "Delivered" .

Best Regards,
Community Support Team _ Ailsa Tao