# Power BI Integration Video Tutorial

> Applies to Automation Cloud Public Sector only.

Applies to Automation Cloud Public Sector only.

**Short description:**This video presents how to GET Automation Pipeline Data to Power BI and create custom dashboards.

The main topics are:

* 00:00 Intro
* 01:00 Setting up the connection from Power BI
* 04:00 Getting the API credentials from Automation Hub
* 04:45 Parsing the JSON response from the Open API
* 05:55 Formatting the table columns
* 08:15 Creating a dashboard from the imported data