[André Stolk]

Hello,

I’m dealing with a connection issue in Power BI Service. My report works fine in Power BI Desktop and I use the same credentials in Power BI Service.
I’m creating a report which dynamically has to retrieve members (user accounts) from AAD groups, using Microsoft Graph API.
For this purpose, I have created 2 functions and 1 connection with a SharePoint list. From the SharePoint list and some added hard coded labels I create a row set which contains group names of the AAD groups from which I want to extract the members (in the screenshot below the most-right column named “PortalTalkGroupName”).

Next I do an invoke of a function “fn_GetGroup” with the two most-right columns as arguments, to get the objectId of those groups:

After expanding the objectId I invoke another function “fn_GetGroupMembers” with the objectId as an argument, to get the members of each group:

After expanding and some filtering the result is a rowset with usernames, email addresses and type of authorization per project:

This approach works fine within Power BI Desktop. But when publishing to PowerBI.com and try to set the credentials for the web connection (required for the 2 functions, I get this error:
Failed to update data source credentials: The credentials provided for the Web source are invalid. (Source at https://graph.windows.net/XXXXXXXX-YYYY-ZZZZ-AAAA-BBBBBBBBBBBB/groups.)

Someone any idea how to get this work on PowerBI.com ?

——————————
André Stolk
Consultant Microsoft Solutions
QS Solutions
Netherlands
——————————