Link to home
Start Free TrialLog in
Avatar of ImageryGrl
ImageryGrlFlag for United States of America

asked on

How do I create a feed (Atom or Rss) of Sharepoint 2010 User Information to pull into PowerPivot

We are creating a PowerPivot enabled dashboard on Sharepoint 2010.  One of the data sources is a Sharepoint list on the same site.  One field on this list is the user who created the record.  When we pull the Sharepoint list into PowerPivot, this field is represented as the Sharepoint ID, not the user name.    

From another post, I determined that I could see the list of users using this type of link:
http://<site>/_catalogs/users/simple.aspx

Is there a way to create a data feed of the UserID and User Name fields that I can use to translate the ID??
I am a Site Collection administrator, but do not have access to the servers.  
ASKER CERTIFIED SOLUTION
Avatar of ImageryGrl
ImageryGrl
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
wow I think this is what I would like to do but I can't get it to work.

can you help out?
Avatar of ImageryGrl

ASKER

Can you click the "Ask a related Question" and post what you are having problems with?