cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
perunt Frequent Visitor
Frequent Visitor

Excel Import Preview

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? 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
perunt Frequent Visitor
Frequent Visitor

Re: Excel Import Preview

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. 

2 REPLIES 2
Community Support Team
Community Support Team

Re: Excel Import Preview

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
perunt Frequent Visitor
Frequent Visitor

Re: Excel Import Preview

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.