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

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?

 

 

  • Yoshimitsu411's avatar
    Yoshimitsu411
    Resolver I
    6 years ago

    The problem has been solved. I got the Admin to format the data as a table from where it is being generated, and sent to the shared mailbox.

     

    Thanks for all your help and suggestions.

     

    Yoshi