Forum Discussion
Import multiple XML files from an folder in Azure Storage Gen2
Hello all,
I have a folder with multiple XML files stored in Azure containers type Gen2, I was able to see my XML files names in Azure storage using "Azure Data Lake Storage Gen2" connector.
My question what is the best way to read all the files in seperate table ? By define a function and parametr ?
Thank you.
Best,
3 Replies
- amitchandak
Super User
MF_BI , This usually I do, It shows me a folder, I filter a table/File and expand it.
Or I use the path till the file name
With this way I should do it file by file after filtering the path.
I want to know if is possible to create parametre (list of path) and function that generate each time one table/file ? Thanks
v-xiaotangCommunity Support
Hi MF_BI
Here is an article for your reference,
https://www.howtoexcel.org/power-query/how-to-import-all-files-in-a-folder-with-power-query/
If this still doesn't solve your question, please let me know.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
