Get Data from Excel File

[kbrewer]

Is it possible to Get only a select number of columns in an Excel File without bringing in the entire page to Power BI Desktop? For example, i have an excel file that my coworker updates. on the left side of the excel sheet he has a " raw data " form of data and to the right of that he has tables that have formulas that add up different parts of the "raw data " next t it. is it possible for me to just select the left "raw data" side of the excel file and bring that in without bringing in the full sheet? 

[v-huizhn-msft]

Hi @kbrewer,

As what @Greg_Deckler said, when you get data from excel, please select the sheet or table name, then click Edit(highlighted in yellow background), you will go to Edit Quey, you can remove any columns you don't need.



Best Regards,
Angelia

[Greg_Deckler · Accepted solution]

Sure, just pull it up in Query Editor, select the columns that you want and then right-click and Remove Other Columns.