Excel Import Preview

[perunt]

I've imported an Excel workbook with multiple tabs of data. For some reason two of the tabs are not displaying the data that is in them when loaded into PBI. When I go to 'Edit query' the data is displayed. It's creating an issue when I go to add a new column.

Has anyone had this issue? 

[perunt · Accepted solution]

The solution was to delete all blank cells in the source excel. Still unsure why it get's loaded in initially with blank rows (at the top) that dont exist in the source excel doc. 

[v-shex-msft]

Hi @perunt,

Nope, I haven't faced similar issues. Can you please explain more about your scenario?

How to Get Your Question Answered Quickly

Regards,
Xiaoxin Sheng