Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi,
I want to extract an XML file which is located on a Sharepoint site. I know how to extract Excel or CSV files from a Sharepoint site (through web or a Sharepoint folder), and I've found documentation on how to extract a local XML file. I haven't found any information on a combination of the two though.
Is it possible to extract an XML file from a Sharepoint site? It could be either using a folder or by extracting the file directly.
Thanks!
Solved! Go to Solution.
Yes, is it a single file? What I like to do for single files is to connect locally first using the XML connector, then just change the path for the file in the source settings to SharePoint. Getting the right path is the tricky bit, you can't use the "copy link" option - you need to go into the file details to get it. I did a tutorial on how to do it here (iirc the example was JSON but the same thing works for XML): https://youtu.be/2HZ8l23RXnc
Yes, is it a single file? What I like to do for single files is to connect locally first using the XML connector, then just change the path for the file in the source settings to SharePoint. Getting the right path is the tricky bit, you can't use the "copy link" option - you need to go into the file details to get it. I did a tutorial on how to do it here (iirc the example was JSON but the same thing works for XML): https://youtu.be/2HZ8l23RXnc
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 9 | |
| 8 | |
| 7 | |
| 6 |