cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
chromo4130 Resolver I
Resolver I

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!

 

CONSULTA 1.JPG

1 ACCEPTED SOLUTION

Accepted Solutions

Re: EMPTY SPACES IN TABLES

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

View solution in original post

5 REPLIES 5
Super User IV
Super User IV

Re: EMPTY SPACES IN TABLES

What is the source?


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Re: EMPTY SPACES IN TABLES

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

View solution in original post

chromo4130 Resolver I
Resolver I

Re: EMPTY SPACES IN TABLES

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!

Super User IV
Super User IV

Re: EMPTY SPACES IN TABLES

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


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Re: EMPTY SPACES IN TABLES

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

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors