Forum Discussion

sentsara's avatar
sentsara
Helper II
8 years ago
Solved

Excel first row removing

Hi, I have excel as Data Source for my powerBI Report. Below is the output of excel:   I need to remove the first row from PowerBI and always it should start from the second row (as an header valu...
Need Help
  • Michal_cwiok's avatar
    Michal_cwiok
    8 years ago

    When you import data from Excel using "Get Data" module, you can select which worksheet to work with:

     

     

    This is where you select it. Do you see the same interface?

Michal_cwiok's avatar
Michal_cwiok
Resolver II
8 years ago

When you import data from Excel using "Get Data" module, you can select which worksheet to work with:

 

 

This is where you select it. Do you see the same interface?

sentsara's avatar
sentsara
Helper II
8 years ago

Thanks Michal.its working now.