Forum Discussion
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 rows in the Excel file but in my Power BI report I only see 6563 rows.
I have tried the following:
- Created a CountRows measure to count the total rows
- Removed all filters from the Excel file as well as in Power Query
- Hit Refresh several times in Power BI desktop as well as Power Query
- Made sure that "Enable Load" option in Power Query for the table is ticked
- Downloaded the Excel file to my local drive and created a new report. This shows all 7250 rows after refreshing several times.
- Tried to keep the bottom 500 rows which did not show the missing rows
- Added an Index column to assist with finding the missing rows
This is a standalone table in the report that has 5 other tables. There is no relationship to the other tables
It seems the refresh preview option is not bringing in all the rows. This is a very important report and must have all the data.
Any suggestions?
Thank in advance.
Yoshi
10 Replies
Yoshimitsu411 , does it show any error in yellow color in edit query/data transformation mode
if you see any error sign
refer, how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTsThanks amitchandak, I checked this. The data loads correctly without any errors, it just doesn't bring in all the rows from the Excel file.
The excel file is stock with no formulas. It is just bizarre that Power BI won't bring in all the rows and I'm stuck!
Thanks again.
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
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
