Bi is not reading all the values from an Excel File

[Shamar93]

I have a table  that I imported from Excel, however I have noticed that from viewing the table in power bi some the cells that are populated in the spreadsheet are being displayed as blank. What could be casuing this?

[v-yulgu-msft]

Hi @Shamar93,

Since Excel file is the data source, did you get table from a worksheet or pivot table? What populated columns were missing? Would you mind sharing me the Excel file so that I can test it in my Desktop? You could send me a private message to share the source file.

Regards,

Yuliana Gu