PowerBI doesn't update in adding new rows Excel

[Anonymous]

Hi, I have Excel sheet located in Sharepoint that's connected to the PowerBI report. This report is set for schedule refresh once everyday. However, on adding new rows to excel sheet doesn't reflect in PowerBI report after the schedule refresh. In first image, you can see I added row 17th but in 2nd image, the PowerBI report only shows till 16th row. Blurred details due to privacy of data. 

Excel sheet image
Excel image
PowerBI image below

Not sure why it's not updating new rows. Although I do want to mention that when I make changes to existing row, say for example in row 9th, it does reflect. Please help! 

[cpwebb]

Power Query can recognise new rows being added to an Excel worksheet as well as an Excel table. However, there are situations where Excel workbooks (especially those generated by applications other than Excel as a result of an export) have incorrect information on where the data in a workbook is. There is an option in Power Query to deal with this problem: https://blog.crossjoin.co.uk/2021/01/17/new-option-to-solve-problems-with-power-query-not-loading-al...

[SJR147]

As a new user (6 months) to Power BI with the same question, I'm surprised by the answer often provided, which is to format the Excel data as an Excel Table instead of a conventional Excel worksheet.  I don't often use Excel Tables and don't prefer using Tables - why is this not portrayed as a major fix needed for Power BI?  If Power BI can import data from an Excel worksheet, can't it provide for the most basic of updates to that same worksheet (like adding rows)?  Does Microsoft have in the works to address this?  All that said, if I have built visuals via a conventional worksheet, and I wish to deal with the issue by changing to an Excel Table, do I need to start over and rebuild the visuals?  Thank you.

[Anonymous]

I have the same issue. And then if I remove the new rows, power bi gives an error and doesn't work any more.

Did you find a solution?

My table on Excel keeps on growing but Power BI doesn't recognize it after 73 rows.

[selpaqm]

@Anonymous please check transform data and to see where the source, sheet or any table inside the sheet. Possibly the root cause is the specific area have been selected as source. 

in case above sitution is not fitting you, if you run schedule refresh for the first time and getting this issue (especially if you have sql server connection) you need to edit all of your sources then schedule refresh reflect the data.

[Anonymous]

Hi @selpaqm I checked in transform data and I see the correct table connected. 
Also, I do not have any sql server connection. Since the excel sheet is in sharepoint, I don't need to setup any gateway, it's already connected since it's in cloud. 

[selpaqm]

if the source is added as table, you have to expand your table area on excel. table end cell has little triangle at right bottom of the cell.

[Anonymous]

Sorry but are you talking about expadning table in report? that still doesn't help because I don't see the added row in the report

[selpaqm]

table need to be expanded in excel.

[Anonymous]

I'm not sure what do you mean by expaning table in excel? Can you explain please 

[selpaqm]

@Anonymous  please check table in excel in picture, there is a yellow highlighted triangle. if you amend the table area then all data will be reflected by power bi