Forum Discussion

Dominic971's avatar
Dominic971
New Member
6 years ago
Solved

Loading multiple CSV files with different schema

I've got 60 CSV files to load in PowerBI Desktop coming from a BLOB storage. All these files are different so different schema.

The "combine" function is not what I want to do.

 

Just want to load all these files to be able to make a report.

 

Could you help ?

 

Need Help
Show and Tell
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Dominic971 ,

     

    You may click the expand icon in upper right corner of the column header. In the column names drop-down, choose any columns you are not interested in. see more details: Expand a column containing a related table (Power Query).

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    Hi Dominic971 ,

     

    You may click the expand icon in upper right corner of the column header. In the column names drop-down, choose any columns you are not interested in. see more details: Expand a column containing a related table (Power Query).

     

    Best Regards,

    Amy

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.