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
v-xiaotang's avatar
v-xiaotang
Community Support
3 years ago

Hi Ah_saaah01 

Thanks for reaching out to us.

That is possible, you can refer to these tutorials,

(1) Power BI DAX | Beginner's Guide to DAX Functions in Power BI (wallstreetmojo.com)

(2) Power BI DAX Tutorial for Beginners | DataCamp

(3) Data Analysis Expressions (DAX) Reference - DAX | Microsoft Learn

 

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.

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.