Power BI not updating new rows from Excel in sharepoint

[Anonymous]

I am feeding my Power BI with an Excel in a Sharepoint.

Previously I have had no issues with this updating but after 74 rows, whenever I add more rows, Power BI do not load them when I refresh.

My Excel file is in a table format and I have tried changing the table size with no luck from Power BI updating.

Also I have tried updating any information on the first 74 rows of the file and Power BI is updated.

I have tried deleting two rows and Power BI update the information but went down from 74 rows updated to 72.

Any changed information on the first 72 rows is reflected in Power BI.

I do not know what else to do or try at this point....... I am a bit desperate...

Could you please help?

Thank you!

[christinepayton]

In the query editor, if you right-click on the query, do you have the refresh box checked there? I have had this exact thing happen and this is what it turned out to be. I had temporarily turned off the refresh on it and then forgot that I had done that. 

[Anonymous]

Hi,

thank you for your reply but yes, it is checked. That is not the issue.

Regards