Forum Discussion
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
- Anonymous3 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
- AnonymousNot 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