Forum Discussion
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-msftCommunity Support
Hi riadorra ,
Which XML database are you trying to connect to? Can you provide more details about your issue?
Regards,
Jimmy Tao