Forum Discussion
Cannot import new rows from access
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
5 Replies
Please show a sanitized version of your Power Query code
Hello! Can you explain how i do that, im not exactly sure how/what you mean by that or where that code is located
In Power BI click
then right click on the query and click "Advanced Editor"
