Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Missing data in some columns when importing an Excel file to PBI

‎09-26-2018 10:05 AM

Hi everyone,

 

I'm having the following problem where when I tried to import an Excel file into PBI, the data was missed out in random columns (or so I thought) while in the Excel file, there was data there.

 

My original Excel file has 51 columns and approximately 52,181 rows. There are blank cells also within some columns and I just filtered the first row as in the titles and did nothing else there.

 

Has anyone encountered this before and how did you resolve it? How did you have a full dataset imported to PBI?

 

Thank you so much! I appreciate any suggestion or help!

 

 

PBI.JPG

Labels:
Message 1 of 2
860 Views
0
1 REPLY 1
Anonymous
Not applicable

‎09-26-2018 11:58 PM

@Anonymous,

What version of Power BI Desktop do you use? Could you please share the Excel file via Private message? I will test it in my Desktop.

Regards,
Lydia

Message 2 of 2
842 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All