Import multiple XML files from an folder in Azure Storage Gen2

[MF_BI]

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,

[v-xiaotang]

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.

[amitchandak]

@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

[MF_BI]

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