Forum Discussion

Jolyon's avatar
Jolyon
Helper III
9 years ago
Solved

wrong import from Excel - empty rows

Hi everyone, I would need your help. I have made a report, importing the data from Excel-Sheet in SharePoint. The idea was, that I refresh this Excel once a week without changing the name or path, ...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi Jolyon,

     

    You will get empty rows when you delete some rows after you first import the data from Excel. For example, at first I import 10 rows from Excel, then I delele 3 rows, after refresh I will get 3 empty rows in Power BI.

    In order to remove the empty rows, you can go to Query Editor, click Filter for your "Category" column, then select Remove Empty.

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

Hi Jolyon,

 

You will get empty rows when you delete some rows after you first import the data from Excel. For example, at first I import 10 rows from Excel, then I delele 3 rows, after refresh I will get 3 empty rows in Power BI.

In order to remove the empty rows, you can go to Query Editor, click Filter for your "Category" column, then select Remove Empty.

 

Regards

Jolyon's avatar
Jolyon
Helper III
9 years ago

Thanks v-ljerr-msft!

well, actually I didn't delete any rows in my first BI report, that's why it's a bit strange, that I have got empty rows from Excel now.

But anyway I just removed now empty rows, as you told. I will see, how the report will refresh next time;)

 

Thank you!