Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |