Forum Discussion
Power BI - Rows Missing in Excel File in Mailbox
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?
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?
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
If you try to use CTRL+T to make all these data in Excel Tables and then try it again.
Regards,
Lin
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
Hello,
I do have a similar issue. I have a simple Excel File. I checked it in the Editor Query and all rows are shown. However, at the table view in the frontend, some rows are missing.
I attached an excel file to check it.
Happy to know what´s going on or what I´m doing wrong.
Cheers
