Forum Discussion

CarlsBerg999's avatar
CarlsBerg999
Icon for Helper V rankHelper V
4 years ago
Solved

Data from SOAP WS to Power BI - Selecting only wanted data

Hi,   I have been working to bring data from SOAP WS to Power BI. I've used the following thread to make my M-code in the query editor: Community thread on implementing SOAP WS in Power BI    Thi...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    HI CarlsBerg999,

    In fact, the current power query seems did not include any features to directly expand to the bottom level.
    Perhaps you can add a custom column to use the M query 'operator' to extract the nest content based on field names.

    Operators - PowerQuery M | Microsoft Docs

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI CarlsBerg999,

In fact, the current power query seems did not include any features to directly expand to the bottom level.
Perhaps you can add a custom column to use the M query 'operator' to extract the nest content based on field names.

Operators - PowerQuery M | Microsoft Docs

Regards,

Xiaoxin Sheng