Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
gbarr12345
Post Prodigy
Post Prodigy

Blank data showing when I add data from Excel

Hi there,

 

I have uploaded data from Excel to Power BI and for some reason there is blank data showing even though there's no blank data in the excel?

 

gbarr12345_0-1724116677379.png

 

 

Can anybody help me resolve this please?

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @gbarr12345 

The fact that you don't see any blank cells in Excel doesn't necessarily mean they aren't there. Sometimes there are hidden blank cells, for example, due to a format applied to an empty cell. To deal with this, you can either filter out the blank cells in Power Query or try defining a dynamic table in Excel using CTRL+T and then import it into Power BI. To assist further, I need to see the file.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

3 REPLIES 3
Ritaf1983
Super User
Super User

Hi @gbarr12345 

The fact that you don't see any blank cells in Excel doesn't necessarily mean they aren't there. Sometimes there are hidden blank cells, for example, due to a format applied to an empty cell. To deal with this, you can either filter out the blank cells in Power Query or try defining a dynamic table in Excel using CTRL+T and then import it into Power BI. To assist further, I need to see the file.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

That;s great, thanks a million Rita!!

@gbarr12345 
Happy to help as always 🙂

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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