Data is loaded into Power BI but not showing in the Data Tab

[Mitch31114]

I have loaded data from an Excel workbook. In the Power Query editer I can see all the data and I just made some edits to the format of each column then Hit close and apply. When in the data view I can see the column headers but I can't see the data its self. If I go to the report tab I can make visuals with the data so it is in Power BI just not showing in that data tab.

I have added pictures of my view from the data tab and the report tab.

I have closed the program, restart my computer and refreshed the data.

[amitchandak]

@Mitch31114 , Most probably that means there lot of empty rows in the source that is also loaded. In power query remove empty rows and then try

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