Here are the steps to talk to the AAD graph API using excel 2013 and power query. The steps are similar to those used when talking to the supported odata feed of the CRM Online service. A workaround is given that makes excel talk to the graphAPI.
1. open an excel workbook and activate the power query ribbon. Select an odata feed:
2. Supply the Graph API URI
From http://msdn.microsoft.com/en-us/library/azure/jj126255.asp
in my case the value is
https://graph.windows.net/rapmlsqa.com/users?api-version=2013-04-05
3. Focus on users
you must select the user form of the URI (and the organizational id option)
4. Sign in and STAY SIGNED IN
4.save the credential set
choosing the users option, and “save”.
One then sees what feels like a bug – where upon one must save again. Note a specific workaround is required. You MUST save again, now as anonymous.
the net result is a query resolution:
