Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |