# Connecting Power BI to the EMC Dashboard

<p class="callout danger">The Power BI connector has been temporarily disabled while we review the security of the connection and the setup process. There is currently no indication of any compromise; this action is being taken as a precaution while we complete our checks.  
  
EMC users will be notified by email once the Power BI connector is available again.</p>

It’s possible to connect to EMC’s dashboard data as if it is a Postgresql Database. This allows you to use SQL to get data from the analytics layer of EMC that powers EMC dashboards. Simplifying business rules and logic.

### Power BI Setup

1. In PowerBI, Click on the **Get data** button  
    ![image](https://support.gapsolutions.com.au/uploads/default/original/2X/0/04b7caeaa8e0250756739750b45a1d61b8980f57.png)
2. Search for PostgreSQL in the list of data sources and click connect
    
    <div class="lightbox-wrapper">[![image](https://support.gapsolutions.com.au/uploads/default/original/2X/c/c66e5fe8d7b3b09d2e269bf985b1dde4e4d9d15d.png)  ](https://support.gapsolutions.com.au/uploads/default/original/2X/c/c66e5fe8d7b3b09d2e269bf985b1dde4e4d9d15d.png "image")</div>
3. Type in the EMC server you are connecting to, the port number 7648 and sql as the database. The Data Connectivity mode can be set as needed to either option.
    
    <div class="lightbox-wrapper">[![image](https://support.gapsolutions.com.au/uploads/default/original/2X/d/da837eac5debfd841c286d2c296c57db9df16e4f.png)](https://support.gapsolutions.com.au/uploads/default/original/2X/d/da837eac5debfd841c286d2c296c57db9df16e4f.png "image")</div>
4. Enter your EMC user credentials
    
    <div class="lightbox-wrapper">[![image](https://support.gapsolutions.com.au/uploads/default/original/2X/b/b3354472183d246915a34a82d9dfcfbd74deedcb.png)](https://support.gapsolutions.com.au/uploads/default/original/2X/b/b3354472183d246915a34a82d9dfcfbd74deedcb.png "image")</div>
5. Select the data tables you want to add to your dashboard  
    ![image](https://support.gapsolutions.com.au/uploads/default/original/2X/c/c2ef4793c27361dae503a4ee14ebf6993b28ae26.png)