Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI added numerous blank rows

Hello,

 

I imported an excel table with my data. For some reason, Power BI added an absurd amount of empty blank cells above my data set. When I go to Edit Queries, my data set looks normal with no additional unnecessary cells.

 

1. Why did this occur?

2. How do I solve the issue?

 

Thanks!

Need Help
  • az38's avatar
    az38
    6 years ago

    Anonymous  it looks like your visual is sorted and yu have an empty rowsin data source.

    to fix it go to the Power Query Editor mode, choose your table, in Home ribbon select Remove Rows -> Remove Blank Rows

    do not hesitate to give a kudo to useful posts and mark solutions as solution

    LinkedIn

3 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    hi Anonymous 

    show us screenshots please

    do not hesitate to give a kudo to useful posts and mark solutions as solution

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Looking at the data set... Empty blank cells that were included.

      Top of the data set

      Scrolled down to row 1,000,000+... Found my data.

      Scrolling down to row 1,0487,654... Data set is found

      Opened the the Edit Queries... Everything looks normal.

      Editing query

      • az38's avatar
        az38
        Icon for Community Champion rankCommunity Champion
        6 years ago

        Anonymous  it looks like your visual is sorted and yu have an empty rowsin data source.

        to fix it go to the Power Query Editor mode, choose your table, in Home ribbon select Remove Rows -> Remove Blank Rows

        do not hesitate to give a kudo to useful posts and mark solutions as solution

        LinkedIn