使用Power m处理xml

Question

我正在努力将xml消息转换为表视图。我一直在寻找它，找到了一些解决方案，没有一个有效，或者我执行得很差。请帮助如何建立电源查询M代码。

Xml信息:

<?xml version="1.0" encoding="UTF-8"?>
<query-response>
<data-table filter="EXAMPLE" count="2">
<columns>
<column>Column01</column>
<column>Column02</column>
<column>Column03</column>
<column>Column04</column>
<column>Column05</column>
<column>Column06</column>
<column>Column07</column>
<column>Column08</column>
<column>Column09</column>
<column>Column10</column>
<column>Column11</column>
</columns>
<rows>
<row primary-key="4844496486">
<field>aa</field>
<field />
<field>3</field>
<field />
<field />
<field>OK</field>
<field>[phone]</field>
<field>[e-mail]</field>
<field />
<field />
<field>Active</field>
</row>
<row primary-key="4668781123">
<field>aa  bbbbb</field>
<field>AAAAAAAAAAA</field>
<field>A</field>
<field />
<field />
<field>OK</field>
<field>[phone]</field>
<field>[e-mail]</field>
<field>CT</field>
<field>false</field>
<field>Active</field>
</row>
</rows>
</data-table>
</query-response>

在PowerBI (PowerQueryM)中所采取的行动的结果应该如下表所示，可以那些&;primary-key&;被提取为Column00吗?

tbody> <<tr>

Column01	Column02	Column03	Column05	Column06	Column07	Column09	Column10	Column11
aa		3			对	+ 4589729222	[e-mail]			活动
aa bbbbb	AAAAAAAAAAA				对	+ 123439843933	[e-mail]	CT	假	活动

参见在Power查询中展开表中的所有列