Forum Discussion

riadorra's avatar
riadorra
Helper II
8 years ago

problem on conteccting power bi with xml database

 Hi,

I've tried to connect with a xml database but when i'm on the load window and flag the "tabel" on the left collumn, instead off showing a sample of the table pbi show's me the mensage "ResponseSuccess" 

 

Please, can anyone help me?

 

I ' m not familiarized with xml so I don't know if my problem is my database or another thing ... 

Follow below on bold the beggining and the end of my data base ...

 

Thank you

Riad

 

 

<?xml version="1.0" encoding="UTF-8" standalone="true"?>

-<Microvix>


-<ResponseData>


-<C>

<D>cnpj_emp</D>

<D>transacao</D>

<D>usuario</D>

<D>documento</D>

<D>ecf</D>

<D>data_documento</D>

<D>codigo_cliente</D>

<D>serie</D>

<D>descricao_cfop</D>

<D>id_cfop_fiscal</D>

<D>cod_vendedor</D>

<D>qtdeproduto</D>

<D>preco_unitario</D>

<D>preco_liquido_item</D>

<D>desconto</D>

<D>aliq_icms</D>

<D>valor_total</D>

<D>forma_dinheiro</D>

<D>forma_cheque</D>

<D>forma_cartao</D>

<D>forma_crediario</D>

<D>forma_convenio</D>

<D>operacao</D>

<D>tipo_transacao</D>

<D>codigoproduto</D>

<D>codebar</D>

<D>cancelado</D>

<D>excluido</D>

<D>soma_relatorios</D>

</C>


-<R>

<D>81777674000107</D>

<D>1937</D>

<D>43</D>

<D>0</D>

<D>0</D>

<D>2015-06-23T12:00:00</D>

<D>1</D>

<D>J</D>

<D/>

<D/>

<D>CARLA</D>

<D>1</D>

<D>300.00000000</D>

<D>300</D>

<D>0.0000</D>

<D>0.0000</D>

<D>300</D>

<D>0</D>

<D>0</D>

<D>0</D>

<D>0</D>

<D>0</D>

<D>S </D>

<D>J</D>

<D>10000000</D>

<D>10000000</D>

<D>N</D>

<D>N</D>

<D>S</D>

</R>


-<R>

 

 

<D>81777674000107</D>

<D>1846</D>

<D>72931</D>

<D>1414</D>

<D>0</D>

<D>2015-06-04T12:00:00</D>

<D>3</D>

<D>1</D>

<D>Compra para comercialização</D>

<D>2</D>

<D>LOJA</D>

<D>1</D>

<D>111.54000000</D>

<D>118.63</D>

<D>0.0000</D>

<D>12.0000</D>

<D>118.630004882813</D>

<D>1</D>

<D>0</D>

<D>0</D>

<D>0</D>

<D>0</D>

<D>E </D>

<D> </D>

<D>1414271711</D>

<D>1414271711</D>

<D>S</D>

<D>N</D>

<D>S</D>

</R>

</ResponseData>


-<ResponseResult>

<ResponseSuccess>True</ResponseSuccess>

</ResponseResult>

</Microvix>

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    Hi riadorra ,

     

    Which XML database are you trying to connect to? Can you provide more details about your issue?

     

    Regards,

    Jimmy Tao