Forum Discussion

PPNewbie's avatar
PPNewbie
New Member
2 years ago

DataFormat.Error: We expected a property 'servicePlans', but the OData service omitted it from the r

I have this code in query powerbi desktop: let resource="https://graph.microsoft.com", tokenResponse = Json.Document(Web.Contents("https://login.windows.net/", [ RelativePath = #"Azure AD Tenant...
Need Help
ronan's avatar
ronan
Frequent Visitor
1 year ago

jennratten I reached this post because I have the same error, but in v1.0 version API.

When I make the request with manager expanded, ie:

my_url = "https://graph.microsoft.com/v1.0/users?$select=id,userPrincipalName&$expand=manager($levels=1;$select=id,displayName,mail)",

graphData = OData.Feed(my_url, [ Authorization = "Bearer " & access_token ], [ ExcludedFromCacheKey = {"Authorization"}, ODataVersion = 4, Implementation = "2.0" ])

 

all users that doesn't have managers would come blank, but I got errors:

 

how could I solve or override this error?