Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Keep blank columns when import excel sheet

Hi, someone can help me with this:

 

I have to import the same sheet from differets paths, so I´ve created a function that do that and extract the third column but sometimes the sheet have the first column blank and power query imported from column B not from column A (because column A is blank). Can I keep all columns when I imported sheet?

 

I want to import all the columns including the empty columns (power query delete automatically) or the first 50 columns.



  • Hi Anonymous ,

     

    You could use Ctrl+T to create a table range in Excel. Then import it in Power BI.

     

2 Replies

  • Before you "Promote Headers" make sure that all columns have a value in the first row.

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support

    Hi Anonymous ,

     

    You could use Ctrl+T to create a table range in Excel. Then import it in Power BI.