Forum Discussion
Anonymous
7 years agoNot applicable
Import multiple XML files with multiple tables
Hi.
I have a lot of files in xml in the same folfer. I am using the import of folder in powerbi. The problem is that i need to expand multiple tables in the power query to have access to all xml data. It is possible to create a custom function and optimize this task? There are more than 100 columns in each xml file.
1 Reply
- v-yulgu-msftMicrosoft Employee
Hi Anonymous ,
You could click the expand button besides column header to expand all "tables".
Best regards,
Yuliana Gu