Table showing blank cells after imported from Excel sheet

[michaelhp]

Hi guys,

I imported a worksheet from the Excel file where data was cleansed a little bit. However, the tables show empty cells like below.

But I can see all the data when I am in the Query Editor mode. Data are available for building visuals as well.

Have you seen this issue before? Please advise if this is a Power BI bug or something I did not do right from my end.

Thank you!

Ping

[quentin_vigne]

Hi @michaelhp

Did you try to refresh the data ? 

- Quentin

[michaelhp]

Hi @quentin_vigne,

Yes, I have tried refreshing the table, but the data are still invisible.

Thanks 

[quentin_vigne · Accepted solution]

@michaelhp

Did you try to remove blank value in the Power Query editor ? 

- Quentin

[michaelhp]

Hi @quentin_vigne,

I tried to remove blank rows in Query Editor and the data were visible after the change was saved, problem solved! 

Thank you so much for your help!

Ping

[quentin_vigne]

@michaelhp

You're welcome ! 

Have a good day

 -Quentin