Forum Discussion
Azure AD Graph Refresh
Yeah :(.
When you run this inside Power Query or PBI Desktop, you either have to enable "Fast Combine" or you need to set privacy levels for the two sources. Currently, all sources inside refresh are marked as "Private" with no ability to change this configuration or set "Fast Combine". This prevents the query from working correctly. This was picked as a default to maximize security without asking the user hard-to-explain questions, but it's obviously quite limiting in the kinds of queries that can be performed -- so we need to figure out how best to enable this scenario for refresh.
It won't refresh,at least with use of function as functions are not supported for refresh
Not sure if will refresh as is not supported but you can try without the function - only one email to see if APIs will refresh
I think yes "from web"= Web.Contents
This is probably my fault for pasting colorized text into the editor. %E2%80%8B is the UTF-8 for an unbreakable space. Can you just retype the line instead of copying and pasting it?
Yeah :(.
When you run this inside Power Query or PBI Desktop, you either have to enable "Fast Combine" or you need to set privacy levels for the two sources. Currently, all sources inside refresh are marked as "Private" with no ability to change this configuration or set "Fast Combine". This prevents the query from working correctly. This was picked as a default to maximize security without asking the user hard-to-explain questions, but it's obviously quite limiting in the kinds of queries that can be performed -- so we need to figure out how best to enable this scenario for refresh.
curth. Ahh. Gotcha. Not a source issue, but a function issue.
This stinks... We have hundreds of SalesForce.com users and I need to mesh up AD data to demonstrate usage-profiling for senior managment.
I tried a PowerPivot approach - however, the Azure AD Graph API seems to limit bulk exports to 100 records. I don't know how to paginate with that API and if i did, I'd probably use a function to loop through a hidden table that has values of 1-99, 100-199, 200.. and so on in PowerQuery. But that would work either since it's a function (right?).
Our regular/internal Active Directory would work fine, but that source isn't supported either.
Oh well. Thanks for the consultaton.
Eric Vogelpohl
Evogelpohl, we're working to enable various scenarios as fast as we can. I don't know if this particular issue is represented yet in UserVoice; feel free to add it and encourage others to upvote it there.
To konstantinos' point, the function is also an issue -- but in this case, we can rewrite the query slightly to fix that problem:
let
FNLookupAD = (EmailAddress as text) =>
let
Source = Json.Document(Web.Contents("https://graph.windows.net/<mydomain>.com/users?api-version=1.5", [
Query=[#"$filter"="proxyAddresses/any(c:c eq 'smtp:" & EmailAddress & "')"]])),
value = Source[value],
This works because the URL is now a literal that's not dependent on the parameter.
curth Thanks. I replace the first few lines of my Fx with yours. I see you're using the query option syntax. However, when i try to invoke that function (just as a test) - I'm getting an error. I did make sure to replace the <mydomain> with my actual domain.com.
I get: DataSource.Error: The remote name could not be resolved: 'graph.windows.net'. I tried in Excel PQ and PBID.
Odd too. I was prompted to re-enter my creds for Azure AD. Previously, I had success using the Organizational Account method, but that too fails with this new approach. I had to enter 'basic'. Perhaps this is why it's failing.
Thanks again for your help.
That seems odd, and unlikely to be related. If you change back to the earlier query, it starts working again?