Power bi is not reading the last row of my raw data from Excel

[rpk00193]

Hi..
I am using Excel as the data source for my Power BI report.

I am updating this Excel document on a regular basis.

Currently, there is not much data, only 50 rows and there is no filter or functions applied on it.
its a simple static values.

I've also converted the data into the table, but when i refresh the data, the Power BI is not reading the last row of my Excel.

for example, if there are 50 rows, then it shows 49 records.
if i add two more records (52) then it shows 51 records.

need assistance.

regards

[audreygerred]

Hello! Does the Excel have 50 rows including the header? In that case, you would have 49 records. Or, is there no header in Excel, but Power BI is promoting the first row to headers? Can you share screenshots or your pbix file?

[rpk00193]

Hi..
Nope.. i've already promoted the first line as a header.
so here i was talking about only data rows.