Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    Hi Anonymous ,

     

    You could click the expand button besides column header to expand all "tables".

     

    Best regards,

    Yuliana Gu