2012년 2월 21일 화요일 오후 5:29
I have some people picker columns in a sharepoint list that display, full name office location, phone number,etc. When I "export as a data feed" to PowerPivot, the columns only display the ID number. same goes for the CreatedBY and ModifiedBy fields. Is there an easy way to get the actual name, phone number, etc to display in the PowerPivot table?
2012년 2월 23일 목요일 오전 8:04중재자
By defaul, besides the user-defined columns, some property columns will also export to the Data Feed, this behavior is by design, if you do not want to conclude these property column, you can utilize "Preview&Filter" to filter these property columns.
For more information about Using SharePoint List Data in PowerPivot, please see this white paper http://blogs.msdn.com/b/analysisservices/archive/2011/06/10/white-paper-published-using-sharepoint-list-data-in-powerpivot.aspx
If I misunderstand you, please feel free to let us know.
TechNet Community Support