Forum Discussion

Yoshimitsu411's avatar
Yoshimitsu411
Resolver I
6 years ago
Solved

Power BI - Rows Missing in Excel File in Mailbox

Hello All   This is a very interesting one. I have an excel file that is in a Outlook 365 shared mailbox which I am connecting to and bringing in the data to my Power BI report.   There are 7250 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    have you doble checked to make sure that the excel data is in a table format? or all the rows are in a table format?

Yoshimitsu411's avatar
Yoshimitsu411
Resolver I
6 years ago

The data in the excel file is not formatted as a table. Is this necessary when you have a large number of rows?

 

I created a separate report with a local copy of the same excel file and it brings in all the rows, after refreshing several times.

 

Thanks

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  Yoshimitsu411 

If you try to use CTRL+T to make all these data in Excel Tables and then try it again.

 

Regards,

Lin

  • Yoshimitsu411's avatar
    Yoshimitsu411
    Resolver I
    6 years ago

    I cannot format as a table as the excel file is auto generated by an application and sent to the Outlook 365 shared mailbox. I will need to write a FLOW to do this and I'm not interested in this as it will involve having to manage the FLOW should it break.

     

    I have found one solution which is to remove all formatting in the excel file by selecting all the rows and then Clear > Clear Formats under the Editing tab. The Power BI report now brings in all the rows.

     

    I will test this again this week to make sure this solution works. 

     

    Thanks for all your suggestions regarding formatting. It definitely set me on the right path.

     

    Yoshi

    • Yoshimitsu411's avatar
      Yoshimitsu411
      Resolver I
      6 years ago

      I'm still having trouble with this issue. Any new rows added to the auto generated Excel file are not showing up in Power BI.

       

      It defintely has to do with the formatting of the Excel file and I'm wondering if there is a way to remove the formatting in Power BI.

       

      Any other suggestions?

       

      Thanks

      • Yoshimitsu411's avatar
        Yoshimitsu411
        Resolver I
        6 years ago

        Hi All

         

        I have tested this on a colleagues computer with the same version of Power BI desktop and he is seeing all the rows.

         

        For some reason Power BI desktop on my computer which is the same version is not showing all the rows. Is it possibly showing cached data?