EMPTY SPACES IN TABLES

[Anonymous]

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!

[Anonymous · Accepted solution]

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]

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]

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

[Anonymous]

At least in my case it wasn't hidden rows - but I think somehow where there was data in the rows at one point they get flagged as "non-empty" and then for some reason deleting them didn't mark them as empty. Then when importing into Power Query they show up...

Not sure why this happens - seems somewhat intermittent, but I haven't spent very much time trying to debug.

Scott

[Greg_Deckler]

What is the source?