Forum Discussion
Power Query unable to retrieve table from a SharePoint person column
Are you using the 1.0 connector? There is a bug with 1.0 where occasionally it won't let you expand person type columns (seemingly at random, though I'm sure there's a reason). I would try using 2.0 list connector, or changing the API version in the advanced query editor from 15 to 14. Be aware that both of these will change the data structure and you'll end up with different column names, so you will have to go back and update or redo any query steps that referenced the old schema.
Are you using the 1.0 connector? There is a bug with 1.0 where occasionally it won't let you expand person type columns (seemingly at random, though I'm sure there's a reason). I would try using 2.0 list connector, or changing the API version in the advanced query editor from 15 to 14. Be aware that both of these will change the data structure and you'll end up with different column names, so you will have to go back and update or redo any query steps that referenced the old schema.