OK, I found the column display name information... it is in ContentType, Fields, Title (really? obviously the last place I looked). Power Query and Power BI should make it easy to surface these names! let //SPListURL is the URL of sharepoint site Source = SharePoint.Tables(SPListURL, [ApiVersion = 15]), //ListTitle is the name of Sharepoint list SPList = Source{[Title=ListTitle]}[Items], #"Removed Other Columns" = Table.SelectColumns(SPList,{"ContentType"}), ContentType = #"Removed Other Columns"{0}[ContentType], Fields = ContentType[Fields], #"Removed Other Columns1" = Table.SelectColumns(Fields,{"InternalName", "Title"}) in #"Removed Other Columns1" |
