read xml attached to sharepoint

[oldrunner]

Hi, 

we are getting information in an xml file which we import into a sharepoint database and we also attach the xml file to the sharepoint record.

Is there any way to get access via Power BI to read / extract the information stored within the attached xml files?

Thanks

Alexander

[oldrunner]

Thanks.

The xmls are stored in a sharepoint list, not a sharepoint folder. I tried to conntect but it didn't work. I only get some unrelated data.

[v-easonf-msft]

Hi， @oldrunner 

What connector you are current using?

Please check the following threads. 

https://community.powerbi.com/t5/Power-Query/Sharepoint-Folder/td-p/525643 

https://www.kizan.com/blog/consuming-xml-web-service-data-in-power-bi 

https://learn.microsoft.com/en-us/power-query/connectors/sharepointfolder 

Best Regards,
Community Support Team _ Eason