Feature Request
POWERBI
Raygun
Jared
Posted on
Aug 19 2024
While we don't currently offer a direct PowerBI integration, I'm excited to share that you can easily create your own custom integration using the new Metrics endpoints in the Raygun API. This approach allows for even greater flexibility in how you visualize and analyze your Raygun data within PowerBI.
This blog post outlines how to use the new endpoints.
To get started with the simplest method of querying the Raygun API from PowerBI:
- In PowerBI Desktop, go to "Get Data" and choose "Web" as the data source.
- Select "Advanced" in the dialog that appears.
- Set the HTTP method to POST and enter one of our metrics endpoints:
- For error metrics:
https://api.raygun.com/v3/metrics/{your-app-id}/errors
- For page metrics:
https://api.raygun.com/v3/metrics/{your-app-id}/pages
- For error metrics:
- In the "Headers" section, add your Raygun personal access token (PAT):
- Key: Authorization
- Value: Bearer {your-PAT}
In the "Body" section, enter your JSON query. Here's a basic example:
{ "start": "2024-08-15T00:00:00Z", "end": "2024-08-16T00:00:00Z", "granularity": "1h", "aggregation": "count", "metrics": ["errorInstances"], "filter": null }
Click "OK" and then "Transform Data" to shape the JSON response into a table format.
This method allows you to pull Raygun metrics directly into PowerBI, where you can then create custom visualizations and dashboards. You can adjust the query parameters to fetch different metrics, time ranges, and granularities as needed.
Remember to use the appropriate PAT token scope(s):
- For error metrics:
metrics:errors
- For page metrics:
metrics:pages