Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

EMPTY SPACES IN TABLES

Hi community,

 

For some reason the loaded tables get empty spaces before my data eventhough the sources doesnt have that empty space... this is the second time I have that problem....anybody knows what could couse this behaviour?

 

 

Thanks in advance for your help!

 

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    I've seen this sometimes when importing from Excel if people had data in cells and then deleted it (although mine appeared at the bottom, not the top like yours are).

     

    I just put a filter in PowerQuery to remove blanks from a column where I know there should always be data.

     

    Hope this helps,

    Scott

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I've seen this sometimes when importing from Excel if people had data in cells and then deleted it (although mine appeared at the bottom, not the top like yours are).

     

    I just put a filter in PowerQuery to remove blanks from a column where I know there should always be data.

     

    Hope this helps,

    Scott

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      It is the same I do... Ill wait if somebody else ffers an a unknown option otherwise Ill give you the kudo!!! greetings and Thanks!

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        7 years ago

        Is this coming from Excel then? Any chance the rows are actually hidden in the Excel file?