Can we connect Xmatters Tool to Power BI

[Manasi25]

Hello team

I wanted to connect Xmatters which to power bi, how can i connect it.

I am using web connection to connect this, but it is navigating me to only HTML view.

[v-sdhruv]

Hi @Manasi25 ,

Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please Accept it as a solution  so other members can easily find it.
Thank You

[v-sdhruv]

Hi @Manasi25 ,

Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please Accept it as a solution  so other members can easily find it.
Thank You

[v-sdhruv]

Hi @Manasi25 ,

Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv · Accepted solution]

Hi  @Manasi25 ,

To connect xMatters to Power BI, you’ll need to use the xMatters REST API to retrieve data in JSON format, and then load it using Power BI’s Web connector.

1.Get xMatters API CredentialsYou’ll need:

Username and password  or a Base64 encoded API token for authentication

2.Find API Endpoint You need
https://<your-company>.xmatters.com/api/xm/1/people

 
3.Get Data
Open Power BI Desktop → Get Data → Web

URL: https://<your-company>.xmatters.com/api/xm/1/people

HTTP Method: GET


Example using Power Query:

let
url = "https://<your-company>.xmatters.com/api/xm/1/people",
headers = [
#"Authorization" = "Basic xxxxxxxxxxxxx==" // Use Base64 of username:password or your token
],
response = Web.Contents(url, [Headers = headers]),
json = Json.Document(response),
results = json[people] // Adjust based on actual structure
in
results

you can find a similar question posted which might help:

https://support.xmatters.com/hc/en-us/community/posts/14519282147867-Use-WebAPI-JSON-for-Power-BI-Da...

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You!

[v-sdhruv]

Hi @Manasi25 ,
Just wanted to check if you were able to resolve the issue?
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You!

[Manasi25]

I wanted an example of how to connect REST API jason 

[pankajnamekar25]

Hello @Manasi25 

Yes, 

USE REST API which provides data in JSON

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.

[Manasi25]

can you show me example?