Forum Discussion
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 ...
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 , 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-Lag0VOiTs
Thanks 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.
