Forum Discussion

Alexbienvenue's avatar
Alexbienvenue
Frequent Visitor
4 years ago

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 ...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
4 years ago

Please show a sanitized version of your Power Query code

Alexbienvenue's avatar
Alexbienvenue
Frequent Visitor
4 years ago

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's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    In Power BI click 

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

    • Alexbienvenue's avatar
      Alexbienvenue
      Frequent Visitor
      4 years ago

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        4 years ago

        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.