Forum Discussion

omerk's avatar
omerk
New Member
10 years ago
Solved

import specific colums from excel

hi,   i would like to import specific colums from an excel file into the power bi. the reason is the excel file keeps on changing and sometimes colums are missing, so i can't just refresh the date...
  • MattAllington's avatar
    MattAllington
    10 years ago

    I assume if you select the columns you want to keep and then select "remove other columns", this should work for you. It shouldn't matter what the other columns are.   So if some are missing, it will still work. But if one of the columns you want to keep is missing, then it will fail

MattAllington's avatar
MattAllington
Community Champion
10 years ago

I assume if you select the columns you want to keep and then select "remove other columns", this should work for you. It shouldn't matter what the other columns are.   So if some are missing, it will still work. But if one of the columns you want to keep is missing, then it will fail

omerk's avatar
omerk
New Member
9 years ago

Hi,

thanks for the response' unfortunately it is not true. if i remove the columns that i don't want (with the power bi query editor) and then the columns are deleted from the excel spreedsheet it will give me an error massage.

any suggestions?

  • MattAllington's avatar
    MattAllington
    Community Champion
    9 years ago

    Did you use "remove other Colums" as I suggested?  Assuming there is a defined set of columns that are always there, select these columns and then use the menu "remove other columns".