DisplayName is null in power Bi but not in graph Api

[Anonymous]

Hello community,

I am actually using graph Api to extract my group members in power bi , but I am facing an issue because the diplay name is null in power bi but not in graph api

here is the query with graph api 

https://graph.microsoft.com/beta/groups/68012e0e-84f4-4b55-bd76-dce430264e23/members/?$select=displa...

and here is the result of the query in graph api

I copied the same query and I used a Odata stream connector in power bi, i get the id but null for displayname :

Thanks in advance

[Anonymous · Accepted solution]

Hi @Anonymous ,

Connecting to Microsoft Graph REST APIs from Power Query isn't recommended or supported. Instead, we recommend users explore alternative solutions for retrieving analytics data based on Graph, such as Microsoft Graph data connect.

Reference: Lack of Support for Microsoft Graph in Power Query - Power Query | Microsoft Docs

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.