In Sharepoint, I have many XML files. I want to automate the workflow in the powerBI.The idea is based on that, there are many XML files in the SharePoint site and I want the "power automate"(or powerquery) tool to check regularly XML files and if there is new one, to get data and append to csv file.
I managed to do it with one XML file which I saved on the local folder, but struggle to make it work with SharePoint.
Is there any chance to do it somehow in powerbi(either with powerbi or something else)
Thanks in advance for your assistance.