Cannot import new rows from access

[Alexbienvenue]

Hello all

Straightforward problem I have no idea how to tackle: 

Storing data in access and have a table called inventory. Today I added 11 new rows of info. Now when I go to update this info to power bi desktop it wont load in. Even went as far as to make a whole new power bi workbook and just upload that one table. The new rows arent appearing in there either. Only a total of 1172 rows in this table

any ideas or thoughts about how to handle this? 

screenshots just to shows rows that are new in access but you can see last record in power bi is 1238, wont add 1272 to 1282 

[lbendlin]

Please show a sanitized version of your Power Query code

[Alexbienvenue]

Hello! Can you explain how i do that, im not exactly sure how/what you mean by that or where that code is located

[lbendlin]

In Power BI click 

then right click on the query and click "Advanced Editor"

[Alexbienvenue]

[lbendlin]

Looks ok. You may have to close your Access app to flush the content to disk so Power BI can read it 

Note: you don't need to sort in Power Query.