Forum Discussion

Shamar93's avatar
Shamar93
New Member
8 years ago

Bi is not reading all the values from an Excel File

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?

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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