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?

sentsara's avatar
sentsara
Helper II
8 years ago

Thanks Michal for quick solution..

 

i have multiple worksheet on the MobileTrade.xlsx.. example below

 

RFC <sheet1>

MobileTd <sheet2>

Bike <sheet3>

 

I need to load only MobileTd sheet from MobileTrade.xlsx.. how we can do this?

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.