Missing Column from table imported from sharepoint list

[Anonymous]

Hi!

After I import a table from a sharepoint list there is one column that isn't there. There are five columns with the same number field type but one isn't there. The name isn't longer, there are no strange characters. But that column doesn't appear. I tried refresh data and it didn't help.

[v-xinruzhu-msft]

Hi @Anonymous 

Did the column is displayed in the view, The SharePoint List 2.0 connector only brings in visible columns by default, you can refer to the following link to know more about it.

https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-online-list#connect-to-sharepoint-online-list-v20

Power Query SharePoint Online list connector - Power Query | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.