用电源处理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>+4589729222</field>
        <field>[email protected]</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>+123439843933</field>
        <field>[email protected]</field>
        <field>CT</field>
        <field>false</field>
        <field>Active</field>
      </row>
    </rows>
  </data-table>
</query-response>

在PowerBi（PowerQuerym）中采取的动作结果应如下表，这些“主要键”也可以作为列00吗？

Column01	Column02	Column03	Column04	Column05	Column07	Column07	Column09	Column10	column10	AA
[		3			OK	+4589729222	电子邮件＆nbsp;受保护]			活跃的
AA BBBBB	AAAAAAAAAAA	A			OK	+123439843933		ct	false	活动

Answer 1

参见在电源查询中的表中扩展所有列