Hi!
I've been trying recently import new columns to my data on power query from an api but when i refresh to get the data it seems that is not importing the columns, it's not anywhere that i could find, it doesn't show in the table, pick columns or the advanced editor
The columns in the advanced editor are like this:
Fonte = Json.Document(Web.Contents("http://000.000000.00:000/api/millenium_omniasystem/movimento/listamovimento?datami=2022-03-01&datamf...")),
#"Convertido para Tabela" = Table.FromRecords({Fonte}),
#"value Expandido" = Table.ExpandListColumn(#"Convertido para Tabela", "value"),
#"value Expandido1" = Table.ExpandRecordColumn(#"value Expandido", "value", {"tipo_operacao", "cod_operacao", "data_movimento", "romaneio", "cod_filial", "nome_filial", "fantasia_filial", "codigo_evento", "desc_evento", "cod_funcionario", "nome_funcionario", "data_nf", "nota", "chave_nfe", "nf_protocolo", "pedido_venda", "prefat_venda", "cod_cliente", "nome_cliente", "cod_fornecedor", "cpf", "cnpj", "rg", "ie", "ddd", "fone", "e_mail", "endereco", "numero", "complemento", "cep", "uf", "cidade", "itens_movimento", "lancamentos_movimento", "qtde", "valor_final"}, {"value.tipo_operacao", "value.cod_operacao", "value.data_movimento", "value.romaneio", "value.cod_filial", "value.nome_filial", "value.fantasia_filial", "value.codigo_evento", "value.desc_evento", "value.cod_funcionario", "value.nome_funcionario", "value.data_nf", "value.nota", "value.chave_nfe", "value.nf_protocolo", "value.pedido_venda", "value.prefat_venda", "value.cod_cliente", "value.nome_cliente", "value.cod_fornecedor", "value.cpf", "value.cnpj", "value.rg", "value.ie", "value.ddd", "value.fone", "value.e_mail", "value.endereco", "value.numero", "value.complemento", "value.cep", "value.uf", "value.cidade", "value.itens_movimento", "value.lancamentos_movimento", "value.qtde", "value.valor_final"}),
I already tried just write the column name on this to bring the column but it doesn´t work too, refreshing data also does nothing, theres nothing wrong with the data and how its written.
Anyone knows what could be the problem and how can i resolve this issue?
