How import define number of columns and rows from excel?

[aaesquivel]

Every day I have to import an excel file with 2000 columns and approximately 1500 rows, for my report in power bi I only need the first 10 columns and 10 rows, is it possible to define the number of rows and columns to import from excel?

[ryan_mayu]

@aaesquivel 

you can do this in the PQ

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-query-overview

[amitchandak · Accepted solution]

@aaesquivel , one of the ways you can try is to select the 10 required columns and right-click and choose remove others.