Exporting Cost Data via Account Management API to View in Power BI

cschmalz — Thu, 24 Oct 2024 13:24:06 GMT

Our finance team needed a solution to export cost data from Dynatrace for forecasting so we built a solution for finance users to view this data inside PowerBI. This enabled users to massage the data to their needs and share it amongst others on their team.

Data flow:

The diagram above gives a visual representation of how the data is delivered to the user. The data automation process is described below:

Dynatrace workflow runs daily pulling data from multiple endpoints under the Dynatrace Platform Subscription path via the Account Management API. More information on this path and API can be found here: https://docs.dynatrace.com/docs/dynatrace-api/account-management-api/dynatrace-platform-subscription-api
Data from these endpoints gets delivered to Azure Blob Storage each in an individual JSON doc
User pulls JSON docs from Azure Blob Storage with SAS token via PowerBI to view cost data
1. When you go to map the first doc's URL it will ask you for the SAS token that will be utilized. This token will be used for the rest of the files in the same blob container:
2. Once data is being ingested, finance team members can use this to make custom graphs and queries like the one shown below:

Further information:

I have attached a template for the workflow with placeholders ("<placeholder>") to input your own variables.
The Dynatrace credential vault is utilized for the blob SAS token and OAuth client ID and secret. The OAuth client ID and secret are used to generate the bearer token that is used to authenticate against the account management API (needs to have account-uac-read scope) which has a lifetime of 5 minutes. More information on the credential vault and creating an OAuth 2.0 client can be found here: https://docs.dynatrace.com/docs/manage/credential-vault
and here: https://docs.dynatrace.com/docs/platform-modules/automations/cloud-automation/setup-cloud-automation/authentication
5 endpoints are specified in the workflow that will get you started and logic may have to be edited depending on how many accounts and environments you have.

Re: Exporting Cost Data via Account Management API to View in Power BI

MostafaHussein — Wed, 23 Oct 2024 20:13:32 GMT

Great topic

topic Exporting Cost Data via Account Management API to View in Power BI in Dynatrace tips

Exporting Cost Data via Account Management API to View in Power BI

Re: Exporting Cost Data via Account Management API to View in Power BI