Click here to download the SQL Server PowerBI Template -OctopusDeployCloud.pbt (https://bit.ly/2ZAKLUr)
|Once you have downloaded the OctopusDeployCloud template, open it up.|
You will see two text boxes.
On the first one, enter the report history URL (https://<yoururl>.octopus.app/api/reporting/deployments/xml).
On the second enter your API key ('API-xxxxxxxxxxxxxx'.).
If you don't have an API Key, see my blog post on how to set one up: https://blog.reviewmydb.com/2020/06/how-to-connect-to-your-octopus-deploy.html
Then click 'Load'.