Forum Discussion

Ah_saaah01's avatar
Ah_saaah01
Helper I
3 years ago

data from different spreadsheets(multiple tables) in different excels, load only few columns

Hi Exports,    I am try to build a past project summery from different excel files. I could format each excels with the identical strucutures. Most cases online shows how to combine all spreadsheet...
Need Help
Ah_saaah01's avatar
Ah_saaah01
Helper I
3 years ago

Sorry I didn't put it really clear, I think I am not asking DAX to calculate a column, but before loading the excel table A2, B2, I would want to use some function to choose maybe one or two specific column from spreadsheet no.2 of all excel files, or create new table based on a summery of only few 

specific columns located in the same place in multiple excels. I am trying to avoid bring all the spreadsheet table into powerBI. 

 

I guess it is M-language when importing data, (sorry still not so sure). Could I manage this with M? 

v-xiaotang's avatar
v-xiaotang
Community Support
3 years ago

Hi Ah_saaah01 

Thanks for your reply.

When you click get data - excel, you cannot choose to import only a single column, but you can remove unnecessary columns in Power Query Editor, and then Power BI Desktop will not load other unnecessary columns

 

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.