Skip to main content

Review My Database

Search This Blog

Parquet, CSV, or SQL Server with PowerBI

on August 22, 2023

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

CSV Design Parquet Performance PowerBI SQL Server Tools

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Comments

Post a Comment

Popular Posts

How To Connect to Octopus Deploy Local Instance

If you have a local instance of Octopus Deploy and need to connect for reporting purposes, you will need permission to access the SQL Server database Octopus Deploy is using. You will need read-only permissions to the table 'dbo.DeploymentHistory'. If you don't have access to the database and table, you can request it from your DBA. To test your access to your local instance, open up SQL Server Management Studio (SSMS). Enter in the server name, and select your authentication type and enter your username and password if necessary, then click 'Connect'. Once connected, you can then test querying the DeploymentHistory and RunbookHistory table. These two tables are the run history tables for Octopus Deploy. USE OctopusDeploy GO SELECT * FROM dbo.DeploymentHistory GO SELECT * FROM dbo.RunbookRunHistory GO If you have access, then you will see results from both of the tables, and you will see records below if any deployments or runbooks have been executed.

How to Connect To Your Octopus Deploy Cloud API

To start setting up your Octopus Deploy API connection you will need an API Key. First, you need to connect to your Octopus Deploy cloud instance and log into your app https://<yourapp>.octopus.app to create an API key. Once you have logged in, click on your 'Name' at the top right of the window. Next, click 'Profile'. Next, click 'My API Keys'. Next, click 'New API Key'. 'Type in your 'Purpose', I put in 'PowerBI Reporting', then click 'Generate New'. After the key is generated, be sure to copy it and keep it in a safe place. Then click 'Close'. You should now see your application listed in your 'API Keys'. Now that you have your API key, you will be able to connect to your cloud instance API. There are several ways of testing your API key. If you are familiar with the program called 'PostMan', you can use that, or if you want to, you can use the built-in 'swagger' comp

How To Configure PowerBI Template for Octopus Deploy Local Instance Reporting

Click here to download the SQL Server PowerBI Template - OctopusDeploySQLServer.pbt ( https://bit.ly/2C9iuvf ) Once you have downloaded the OctopusDeploySQLServer template, open it up. You will see PowerBI attempt to refresh the data, you will see the pop-up below, click 'cancel'. Now from the 'Home' bar, click 'Transform data' and select 'Data source settings'. Click on 'Change Source...'. Enter in your local SQL Server name and instance if needed, and enter your database name, then click 'Ok'. Now you should see your server and database listed, next click on 'Edit Permissions...'. Now under Credentials, click 'Edit...'. If you notice the current type is 'Database'. If you are going to connect using SQL Server database user account, select 'database' then enter your username and password and click 'Save'. If you use Windows Authentication, select 'Windows' and select either

Powered by Blogger

Copyright ReviewMyDB 2018-2020