Missing column from sharepoint

[Dunner2020]

Hi there,

I am trying to get the data froom sharepoint list. When I looked the data not all columns present on the sharepoint appear in the table view. In power query editor mode, when I click on the 'FieldValuesAsText' column, I could see list of columns that already visible on the table view. It also put the note that 'List may be incomplete' option as shown in the following figure:

When I clicked on 'load more' option, all visible column name disappeared. I am not sure where to see the missing columns

[amitchandak]

@Dunner2020 , Usually load more should work. If you are March 2021, Close the file and open and try again, I faced few issues like tables were not visible in the data model, etc, Initially after the upgrade.