Forum Discussion

jeggen's avatar
jeggen
Helper II
3 years ago
Solved

Workday XML Import

I am trying to import from a Workday XML URL into PowerBI. So far I've been using "web" source and the Workday URL. The data pulls in but several of the items come in as tables which need to be expanded and then cleaned up since additional information from the XML formatting itself seems to be coming in. The original report in Workday is clean, the issue seems to be occuring on the import into PowerBI.

 

There are serveral third party tools out there I've seen but wondering if anyone here has a suggestion on how to bring in a Workday XML File via URL into PowerBI? Do I need to use a different source type? I tried XML but that just seems to look for a file.

 

Thanks

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi jeggen ,

     

    About power bi import XML file, it is described in this document, and I hope it will be helpful to you:

    Power Query XML connector - Power Query | Microsoft Docs

     

    Best regards,

    Community Support Team Selina zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi jeggen ,

     

    About power bi import XML file, it is described in this document, and I hope it will be helpful to you:

    Power Query XML connector - Power Query | Microsoft Docs

     

    Best regards,

    Community Support Team Selina zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly