Transferring Data To Power BI

[Anonymous]

Hi,

I am trying to transfer an excel worksheet to power bi and it loads correctly in the data preview with shown nulls, but when I load the actual data, nothing pops up besides the headers. 

Any and all help will be appreciated. 

[amitchandak]

@Anonymous , I think there are empty rows in data. In power query use remove Empty rows try

Remove Empty and Remove duplicate Rows (Power Query) : https://youtu.be/Hc5bIXkpGVE

In dataview, check no of rows, left bottom. sort and check

[Anonymous]

Thank you, I did that but I also have empty columns, is there a way to remove all of those in one action instead of individually going and removing each?