Why does my data not shown when loaded onto PBI?

[Anonymous]

Hi all,

Need your help to troubleshoot for me this particular issue I'm facing...

I loaded an Excel workbook onto my existing PBI by clicking "Excel Workbook" and then  "Load".

The data was loaded but it became  invisible like this below. 

However, when i click "Edit Query" the data is fully shown in this tab. 

Why is that 

[amitchandak]

@Anonymous , I doubt empty rows also got loaded. in power query remove empty rows and then try

Power Query Remove Empty/Duplicate rows: https://youtu.be/Hk8QtBfcm6k

[Anonymous · Accepted solution]

Hi @amitchandak,

Thanks for the tip. I realised there were extra empty rows when it was copied and pasted in Excel. Deleted that and it solved the problem.