Connecting to Graph API through Odata feed - permission issues with some queries

[rarowston]

Hi all.

I have been trying to connect to the Microsoft graph API through an OData feed in Power BI. I understand that the OData support in this API is patchy with different commans and types of filters being supported on different endpoints, however, this seems to work for simple queries. 

My problem is that for some operaions that I know the API supports it gives me the error: "Expression.Error: Access to the resource is forbidden."

The present instance of this problem is with the groups endpoint (https://graph.microsoft.com/v1.0/groups). I can query the endpoint raw perfectly fine. However, I need to expand the members field for each group, and when I attempt to do this the above error occurs. I know I have sufficient permissions for this as I have successfully run this query through the graph explorer (Query: https://graph.microsoft.com/v1.0/groups?$expand=members). 

I can successfully expand other fields in the groups dataset in PowerBI, it is just members that causes this issue (as far as I have found).

Does anyone know or have an idea of why this doesn't work from within PowerBI? 

Thanks

Ryan