Forum Discussion

johnsmolenaers's avatar
johnsmolenaers
Regular Visitor
2 years ago
Solved

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

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 ...
Need Help
  • johnsmolenaers's avatar
    johnsmolenaers
    2 years ago

    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's avatar
GilbertQ
Super User
2 years ago

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's avatar
johnsmolenaers
Regular Visitor
2 years ago

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