Failed to test the connection to your data source for Graph API source

[johnsmolenaers]

Hi All,

Firstly appologies my poor understanding of Power BI. I am only just starting out 😁.

I have created a proof of concept Power BI report in the desktop version that uses a Power Query to extract some data from the Microsoft Graph API https://graph.microsoft.com/v1.0/security/runHuntingQuery I have setup an App Registration with the necessary API permissions so I can autheticate to the API used the App Registration (i.e. Tenant ID, Client ID and Client Secret). This works perfect in the Power BI Desktop report.

I have now published the report to a workspace on the Power BI Server (app.powerbi.com) but the report failes to refresh the data. Looking tat the Semantic Model settings, the Data Source Credentials, I see it is failing its test for the https://graph.microsoft.com/v1.0/security/runHuntingQuery connection. The error I get is:

Failed to update data source data source credentials: The credentials provided for the Web source are invalid. (Source at https://graph.microsoft.com/v1.0/security/runHuntingQuery.)
Activity ID: 1f39573a-30ae-4959-86f2-1a8d4282a616
Request ID: a1361ba4-5501-2089-c01b-c176454cb8fd
Status code: 400
Time: Tue Aug 06 2024 14:50:18 GMT+1000 (Australian Eastern Standard Time)
Service version: 13.0.23827.61
Client version: 2407.4.20134-train
Cluster URI: https://wabi-australia-southeast-redirect.analysis.windows.net/

When I edit the credentials, I am setting it the same as in the Power BI Desktop version as per the screenshot.

I have no idea what the issue is or even if what I am trying to do is possible 😔

Any help would be greatly appreciated.

[johnsmolenaers · Accepted solution]

In the end I gave up on trying to have my symantec model refresh data from Graph API when using the Power BI Service. Insted I create a Logic App in Azure that made the Graph API call the called my Logic App from the Symantec Model to work around the authetication issue.

[GilbertQ]

Hi @johnsmolenaers 

How are you passing the service principal credentials to the API? Is this within power query? If it is, you should be able to click on skip test connection and see if that works.

[johnsmolenaers]

Hi @GilbertQ,

I put the Tenant ID, Client ID and Client Secret for the App Registration into parameters then referenced those parameters in the section of my Power Query to get the authorisation token.

I did try and skip the connection test but the data fails to refresh after a long time of trying with the following error:

Data source error: Information is needed in order to combine data. Please specify a privacy level for each data source.;Information about a data source is required.. The exception was raised by the IDbCommand interface. Table: EmailActionPolicyByPeriod.
Cluster URI: WABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net
Activity ID: e5cb501e-1f97-4edd-8885-ef7c6d836ca5
Request ID: 63ecec7a-9a25-490e-72cf-aa6bf3f5d203
Time: 2024-08-06 22:49:56Z